NEGATIVE HOURS (2)

[André Lavoie]

Thanks, the previous tip about negative hours worked very well. Now, how
could I enter a negative hour directly into a cell without calculation?.
when I tipe -2:00, I recieve an error message

Any ideas ??

André Lavoie

 

[Tom Ogilvy]

There may be an easier way, but enter 2:00. then in another cell enter -1,
copy it, select the original cell and do Edit=>PasteSpecial and select
multiply.

You can also do: =TIMEVALUE("2:00")*-1

but the easiest I found was to enter

-2/24

or -(2+(13/60))/24 to get -2:13 as an example. Format the cell as time of
course.
or -2.23/24 to get 2:15 as another example.

Time is stored as the fraction of a 24 hour day.

 

[Harald Staff]

Hi Andre

Enter
=-"2:00"
It will display -0.083333 if unformated and ####### if timeformatted. But
it's there, ready to calculate.

user friendly ? Not really ;-)

HTH. Best wishes Harald

 

[Charles]

André Lavoie

Try Formating the cell with custom:
-h:mm

HTH

Charles

 

[Tom Ogilvy]

xl97 SR2, Win 98 SE
that didn't work for me. Did it work for you - what version of Excel?

Unless you meant enter a positive time and have it appear as negative.
(don't see much use for that).

 

[Charles]

Tom,

Excel 2000, Windows XP Home.
I too don't see a need. but my formula worked.

Charle

 

[Tom Ogilvy]

You didn't answer the question. Did you enter -2:00 directly in a cell, or
did you enter 2:00 in a cell and have it appear as -2:00

 

[Charles]

Tom,

I just entered 2:00 and it displayed -2:00.
Also I don't know why André Lavoie would want this.

Charle

 

[Tom Ogilvy]

He doesn't. He wants to enter -2:00 directly, not have it just display as
negative.

 

[Charles]

Tom,

Thanks my error.

Charle