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

Convert decimal days to Days,hours, minutes
 

Give the cell the custom format d:h:mm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Todd F." wrote in message
...
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

Convert decimal days to Days,hours, minutes
 

Use custom format, something like

dd":"hh:mm

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Todd F." wrote in message
...
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

Convert decimal days to Days,hours, minutes
 

thank you and then I used y:dd:hh:mm for times exceeding 1 yr

"Bernard Liengme" wrote:

Give the cell the custom format d:h:mm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Todd F." wrote in message
...
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