Thread: Difference between 2 times
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David J Richardson David J Richardson is offline
external usenet poster
  
Posts: 6
Default Difference between 2 times
In article ,
"Niek Otten" wrote:

Just subtract one from the other and format the result in some time
format that doesn't give you the AM/PM

But be cautious doing comparisons between the difference and another
value (ie. was the difference less than or equal to 3 minutes 20
seconds?). You'll almost certainly have an answer of the form
19.99999975632 or 20.00000018463 seconds.

--
David J Richardson --
http://davidj.richardson.name/ - Dr Who articles/interviews/reviews
http://www.boomerang.org.au/ - Boomerang Association of Australia
Reply With QuoteReply With Quote