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

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

Thanks Dave

That works great.

Bryan


--
BryHam
------------------------------------------------------------------------
BryHam's Profile: http://www.excelforum.com/member.php...o&userid=25189
View this thread: http://www.excelforum.com/showthread...hreadid=386780