View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default expressing minutes negatively

ToolsOptionsCalculation check Calendar since 1904

Format your result as [h]:mm:ss

HTH
--
AP

"DJ" a écrit dans le message de
...
I can figure out how to subtract one date/time from another, but the

answer
is always expressed "positively". I am trying to express a negative

value.
In other words, I'm trying to show a difference (in hh,mm) of something

being
"early" by 15 minutes versus being "late" by 15 minutes.