Negative Time

[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

 

[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

 

[BryHam]

Thanks Dave

That works great.

Bryan