View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alex alex is offline
external usenet poster
 
Posts: 25
Default hours converted to Days hours and minutes

Is there a function or a code I can create in Excel where
I can create hours into days with hours and minutes. For
example I have 10.66 as hours..I want to change that in
another cell to read 10 hours and whatever minutes .66
resepresents I think its like 37 minutes or so.. the same
if I had lie 28.5 hours..want it to read 2 days 4 hours
and 30 minutes. Thanks