View Single Post
  #3   Report Post  
David McRitchie
 
Posts: n/a
Default

See Biff's answer. Comparison on the Minute component will not work because
it will only show 5 minutes for 15:05:30 (15 hours + 5 minues +30 seconds).
and that number certainly exceeds 15 minutes.

for more information on Date and Time see
http://www.mvps.org/dmcritchie/excel/datetime.htm-
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm