Thread: Negative Time
View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

=-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