minus hours

M

maccaz

I'm sure this has been asked before, but how do you enter minus hours.

I'm trying to start of the month with -6:00 hours flixi, but when
enter that number it comes up with an error
 
J

Jazzer

Hi,

Excel doesn't support negative time in it's "basic" settings. How ever
you can use "1904 date system" (Tools -> Options -> Calculation -> 190
date systems), which support negative time.

More info can be found from Excel help. In XL2003, it's under titl
"About dates and date systems"

- Asse
 
J

Jason Morin

Try:

-6/24

and format as time. Because it is negative, it will show
#########. However, the time can be still be used in
calculations. To display it as negative time in text
format, try:

=TEXT(-A1,"-[h]:mm")

HTH
Jason
Atlanta, GA
 
Top