Thread: How do I convert hours to days?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WBJ WBJ is offline
external usenet poster
  
Posts: 2
Default How do I convert hours to days?
I am entering start-times and end-times (cols. A & B) and calculating the
duration (col B - col A) in C. I want to format the sum of all durations --
28:30, for instance (28 hours, 30 minutes) for an 8-hour day as 3 days, 4
hours, 30 minutes.

Any ideas?
Reply With QuoteReply With Quote