G Guest Feb 7, 2006 #1 Total hours available less hours worked each day, allow results to go negative. Excel displays negative times as #.
Total hours available less hours worked each day, allow results to go negative. Excel displays negative times as #.
D daddylonglegs Feb 7, 2006 #2 You can generate negative times if you use the 1904 date system Tools > Options > Calculation > 1904 date system ....although if you use on an existing worksheet it'll make all your dates 4 years later!
You can generate negative times if you use the 1904 date system Tools > Options > Calculation > 1904 date system ....although if you use on an existing worksheet it'll make all your dates 4 years later!
