negative hours

[Rodolfo Fontes]

Hi group,

How can I see negative hours on Excel?
I´ve subtracted 12:00 from 9:00 and the result should be -3:00, and Excel
shows #####. How can I solve that?

Thanks,
Rodolfo Fontes

 

[JE McGimpsey]

One way:

Tools/Options/Calculation, check the 1904 Date system checkbox.