View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default making a time a measurement of time, not an hour of the day??

Hi Tom,
and since it looks like you will probably needing additional help with
understanding and using date and time suggest you look over
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/excel.htm

You might also keep the format [hh]:mm or [h]:mm
in mind to keep hours from overflowing into days when
you add up a column of times.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Phillips" wrote ...
Format that as hh:mm