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?
try time-1
Yea_So actually this simple formula works well, when displaying negative time. Its value can also be used in formulas.
I used a combination of the 1904 system date (under Options...), changing the cell format to [hh]:mm (so that I can calculate 40 hours of labor, etc), and using time.
I have an excel sheet with work hours, vacation hours, etc.