Negative time format?

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

I want to display a negative time (i.e. how many hours
minutes and seconds one event occurred before another),
but the custom format for elapsed time [h]:mm:ss just
returns a string of # signs. If it were only for display
I could cheat, reverse the calculation and format it as "-
"[h]:mm:ss, but I really need the value to actually be
negative so it doesn't appear on a related graph.

Any suggestions?

Many thanks, Geoff.
 
Hi Geoff!

You could use the 1904 Date system as this allows negative times.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top