| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract hours from a time and get the correct time
I am trying to subtract 7 hrs from different times entered and get the
correct time. It works fine until it goes back to the prior day. How do I get it to display correctly? I am using Excel in Office 2007. I entered =1:18-7:00 and have a cell format of hh:mm AM/PM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract 8 business hours from a date/time value? | Excel Discussion (Misc queries) | |||
| How do you subtract time as in a timecard to calculate hours work | Excel Worksheet Functions | |||
| Time/Date subtract 24 hours | Excel Discussion (Misc queries) | |||
| Subtract time between certain days/work hours? | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Threaded Mode
