View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default Negative time value hh:mm:ss

Try 1904 type date format:

Tools/Options/Calculation tab/(bottom left corner)

Note that changing to the 1904 date system will cause all your
existing dates to be off by 4 years and a day

OR

F1: <end time
F2: <start time


As Excel shows negative times as ##### take largest from smallest and prefix
by negative sign.

=IF(F1<F2,TEXT(F2-F1,"-" & "hh:mm"),F1-F2)



"Jelinek" wrote:

i have two columns of data both time formats when i subtract one from the
other it displays ###### if it is a minus value is there away to get round
this i would like to view the diffrence even if it is a minus amount.

Thanks

Simon