formula help working with time
 

For example, I have a cell that is formatted [h]:mm and indicates 50:03 (50
hours 3 minutes) and I need to convert it to days, hours, minutes. Is there
a formula I can use? I tried dividing by 24 but my answer was 2:05 using the
[h]:mm format but if I use General or Number formating I get 0.08689.
Thanks for your assistance.
--
Constance

formula help working with time
 

Hi!

Use a custom format:

d h:mm
d - h:mm

Biff

"Constance" wrote in message
...
For example, I have a cell that is formatted [h]:mm and indicates 50:03
(50
hours 3 minutes) and I need to convert it to days, hours, minutes. Is
there
a formula I can use? I tried dividing by 24 but my answer was 2:05 using
the
[h]:mm format but if I use General or Number formating I get 0.08689.
Thanks for your assistance.
--
Constance

formula help working with time
 

Hi Constance

One way
=INT(A1*24/24)&" days "&(INT(MOD(A1,24))&" hours "
&CEILING(MOD(A1,1440),1)&" minutes")
--
Regards

Roger Govier


"Constance" wrote in message
...
For example, I have a cell that is formatted [h]:mm and indicates
50:03 (50
hours 3 minutes) and I need to convert it to days, hours, minutes. Is
there
a formula I can use? I tried dividing by 24 but my answer was 2:05
using the
[h]:mm format but if I use General or Number formating I get 0.08689.
Thanks for your assistance.
--
Constance