| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subracting Time.
How do I subtract time?? For example
A1=20:00 HRS B1=15:00 HRS C1=(A1-B1)-1 I want to always subtract 1:00 hour from the result. , =(A1-B1)-1 I get, ###### How can I get 4:00 as the answer?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| adding and subracting credits | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Subracting Dates to come up with the # of days between them | Excel Worksheet Functions | |||
Threaded Mode
