| 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 |
| 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 | |||
Threaded Mode
