Home » Any Answers » Negative time

Negative time

Posted by jpcc1 PM | on Mon, 14/02/2011 - 09:50  1888  5 comments | report

How can I format a cell so that it displays a negative time rather than ####  ??

e,g, for use in flexi- time calculations.

Comments
There are 5 comments. Login or register to view them.

Negative time

shurst | Mon, 14/02/2011 - 10:33
shurst's picture

Funny you should ask

John Stokdyk | Thu, 17/02/2011 - 10:00
John Stokdyk's picture

Personally I use 2 columns/rows

DerekChaplin | Thu, 17/02/2011 - 13:47
DerekChaplin's picture

MAX() and MIN() v IF()

shurst | Thu, 17/02/2011 - 14:12
shurst's picture

Negative times

jason.raikes | Thu, 17/02/2011 - 14:35