Home |
Search |
Today's Posts |
#1
|
|||
|
|||
get total hours from 2 dates
I need the total time from to dates.
My class starts on 6/10/2005 8:00 My class end on 6/11/2004 16:00 My excel spreadsheet has 6/10/2005 8:00 in one cell and 6/11/2004 16:00 in another. When I just do a date difference I get about 32 total hours which is wrong. The total hours should be 16 hours since the class runs from 8:00 to 16:00 each day. Help please |
#2
|
|||
|
|||
Hi!
If your class days are always Monday through Friday you could use the Networkdays function for this.(and the formula would be less complicated than the one below!) Here's something that will work: A1 = 6/10/2005 8:00 B1 = 6/11/2004 16:00 =((INT(B1)-INT(A1))-1)*8/24+SUM(MIN(16/24,MOD(B1,1))-8/24,MAX(16/24,MOD(A1,1))-8/24) Format the cell as [h]:mm Biff "LU" wrote in message ... I need the total time from to dates. My class starts on 6/10/2005 8:00 My class end on 6/11/2004 16:00 My excel spreadsheet has 6/10/2005 8:00 in one cell and 6/11/2004 16:00 in another. When I just do a date difference I get about 32 total hours which is wrong. The total hours should be 16 hours since the class runs from 8:00 to 16:00 each day. Help please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
scheduled hours total | Excel Discussion (Misc queries) | |||
how do I total hours and mins in excel | Excel Worksheet Functions | |||
Calculating Overtime from Hours total | Excel Worksheet Functions | |||
Problems calculating total hours | Excel Discussion (Misc queries) | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |