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
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
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." <[email protected]> wrote in message
news:[email protected]...
> 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
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." <[email protected]> wrote in message
news:[email protected]...
> 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
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." <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks