| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding/subtracting time
I have a worksheet with times formatted as [$-409]h:mm AM/PM;@. I
don't understand the format and would like to be able to subtract times to get total hours. i.e. start time = 2:00 PM and end time= 10:00 PM Hours=8 start time = 10:00 PM and end time= 2:00 AM Hours=4 Since I don't understand the current time format (or why they didn't just use an existing MS format), I don't know how to get my calculation to work. TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time log adding time from separate sheets | New Users to Excel | |||
| Entering Times | Excel Discussion (Misc queries) | |||
| time differences in a column | Excel Worksheet Functions | |||
| Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Threaded Mode
