Negative time format?

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.
 
N

Norman Harker

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert time as text 'mm:ss to time value in Excel 5
Excel Convert Datetime Stamp to HH and MM Worked 7
Custom format mm:ss 3
Time Format 4
Show time as a negative figure 3
Time format conversion 7
Excel 2003 - Time Formats 5
stopwatch times 7

Top