Thread: How do I convert hours to days?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Steven Steven is offline
external usenet poster
  
Posts: 21
Default How do I convert hours to days?
Assuming the sum of all durations in cell A1
To return the value of days =DAY(A1*3)
To return number of remaining hours =(+A1*3-DAY(A1*3))*8
To return minutes = MINUTE(A1)

If you wish you can display all 3 formula together in one cell by
joining them with
=DAY(A1*3)&" days "&(A1*3-DAY(A1*3))*8&" hours "&MINUTE(A1)&" minutes"
Let me know if this helps
Reply With QuoteReply With Quote