Time 0 with negative sign

-1

I have an excel spreadsheet which I changed the date system to 1904 to be able to display negative hours. The problem is that it often happens that -00: 00 values appear when I subtract timings.

What I have analyzed is because the date is 01/01/1904, but in the field I do not want to display the date, I only care about the schedules.

I've tried using SE function to identify if it is less than / equal to zero and does not resolve. Anyone have any suggestions?

    
asked by anonymous 21.08.2018 / 22:16

1 answer

2

Solved, I adapted the TEXT function (suggested by my colleague):

= SE (TEXT (F4-E4; "[hh]: mm")="-00: 00"; "00:00"     

22.08.2018 / 19:12