negative working hours

[Berna11]

Good evening, I would like to manage the working hours but negative with the formulas by mistake when you subtract a smaller value.
I used a function

Please Login or Register  to view this content.

But even this in a few lines from the wrong values.See attached file
You can correct it or tell me another way to get your hours in negative values?
Thank you

[Special-K]

Just use

=(E5-D5)*24

That won't produce the nuber of minutes though, it will be a percentage of an hout
e.g.
-15.25 instead of -15.15

[rollis13]

If you only have calculations with hours (no dates) you could change the 1904 option in File/Options/Advanced/Use 1904 date system/ then you can simply use the formula =E5-D5 even for negative calculations.

[Berna11]

I tried with:

= IF (E5<D5;((E5-D5)*24);E5-D5)

but by the same mistake.

Not a single line but many, and I need the exact value in hours and minutes.

[Berna11]

Thanks, Rollis13 but I would not change the settings in 1904
I might have errors in other files.

[ChemistB]

You could use this formula

=IF(SIGN(E5-D5)+1, TEXT(ABS(E5-D5),"[h]:mm"), "-"& TEXT(ABS(E5-D5),"[h]:mm"))

[rollis13]

The option will be only for that single file.

[Berna11]

I tried the formula ChemistB and apparently functions properly.
For now I thank you if I have problems I will hear.