| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time/Date subtract 24 hours
I am trying to show the date and time when I subtract hours:min from a date
and time. Currently the formula I am using is $I$64-TIME(F14,G14,H14) where I64 contains the date and time, F14 is hours, G14 is minutes and H14 is seconds. Everything works great until I get to 24 hours. The date reverts back to the original date, but the time is correct. How do I get the date to calculate correctly? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract time between certain days/work hours? | Excel Worksheet Functions | |||
| subtract hours | Excel Worksheet Functions | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| excel [HHHHH]:mm add subtract hours mins inc lnegative | Excel Worksheet Functions | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Threaded Mode
