|
|
=-time(8,30,0)
is one way.
BryHam wrote:
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
------------------------------------------------------------------------
BryHam's Profile: http://www.excelforum.com/member.php...o&userid=25189
View this thread: http://www.excelforum.com/showthread...hreadid=386780
--
Dave Peterson
|