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 - 14 Sep 2005 16:45 GMT
One way:
Tools/Options/Calculation, check the 1904 Date system checkbox.
> 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?