Negative Time

B

BryHam

I am trying to set up a time-sheet which records flexi-time. Obviously
when someone accrues flexi the hours and minutes add to each other.
However when someone takes flexi this is a negative number.

Even with the 1904 date system on you can't type a negative number in a
time formatted cell.

Does anyone know of another way to do this?

Thanks

Bryan
 
D

Dave Peterson

=-time(8,30,0)

is one way.
I am trying to set up a time-sheet which records flexi-time. Obviously
when someone accrues flexi the hours and minutes add to each other.
However when someone takes flexi this is a negative number.

Even with the 1904 date system on you can't type a negative number in a
time formatted cell.

Does anyone know of another way to do this?

Thanks

Bryan
Click to expand...
 
Top