Forum Discussion
Write negative hours in Excel cell
Hi, when I try to insert a negative time in an Excel cell, for example -10:12, Excel interprets the input as the selection of lines 10-12, and not as a time. Can you help me solve this problem?
'-10:12?
Xaraox_ sure! As long as you're not using that said data to add/subtract.
E.G. employee John used 1 hour for Personal.
How would I, then delete from his Personal Pool?
the '-10:12 that you suggested wouldn't allow. Now, =-Time(10,12,0) would.
So would changing the format to [hh]:mm.
So would, in a way (calculating between two (or more) cells containing times) using the 1904 Date system.
I'm new to this, so just trying to help fellow Excel users.
Cheers!
