Thread
:
Convert decimal days to Days,hours, minutes
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Todd F.
Posts: n/a
Convert decimal days to Days,hours, minutes
Is there a way to convert decimal days to days:hrs:min.
So 1.5 would be "001:12:00" in the cell, 1 day , 12 hours
or 0.25 would be "000:06:00" in cell, 6 hours
thanks for your time
Reply With Quote