| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Bingo! That worked great - thank you for your help.
"JE McGimpsey" wrote: Sorry - If you're using the WinXL default 1900 date system, that indicates that the result is negative, and that date system can't display negative times. Instead, use =MOD(A1-TIME(5,0,0),1) In article , "Erika" wrote: I tried the first example you gave =A1-TIME(5,0,0) - however my result is ########## that no matter how wide I make the column it keeps doing that. I got the same result with your second suggestion. Do I need to select a different time format? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel [HHHHH]:mm add subtract hours mins inc lnegative | Excel Worksheet Functions | |||
| calculating hours | Excel Worksheet Functions | |||
| calculate hours just can't figure it out | Excel Worksheet Functions | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Hybrid Mode
