Thread: Converting total number of hours (24 hours) into days
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MV Rao MV Rao is offline
external usenet poster
  
Posts: 1
Default Converting total number of hours (24 hours) into days
I have a series of cells containing time spent. When I sum them up, it is 24
hours. When I format the cell with [h]:mm, I can see the total correctly. But
I want to calculate number of days by dividing this hours by 8. How do I do
it?
--
MV Rao, VP
Reply With QuoteReply With Quote