net no of hours bewtween tow dates

K

Kashif

I wanted to know net no of working hours between following two dates;

Time Start 23-Sep-2008 13:43
Time End 30-Sep-2008 18:24
Holiday 29-Sep-08


Kashif
 
M

Mike H

Hi,

The answer depends on how long a day is. Is it 24 hours or limited to the
hours in your working day.

If a day is 24 hours long use this
=(NETWORKDAYS(A1,B1,Holidays)-1)+MOD(B1,1)-MOD(A1,1)

If a day is (say) 08:00 - 17:00 use this
=(NETWORKDAYS(A1,B1,Holidays)-1)*("17:00"-"08:00")+MOD(B1,1)-MOD(A1,1)

In both case the start time is in A1. End time in B1 and Holidays is a named
range that contains your holiday dates.

Format both as [hh]:mm

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Dates in a range based on Column Header Id without using sum-product 1
Date Time increment with additional condition of skipping weekends 18
Formula convert date to month format 7
When building a chart Dates are been included that are not in thedate range 2
Help!!!! 0
Subtracting time...again 2
How do I combine 2 data sets using date? 2
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2

Top