Convert Hrs:MM:SS to number of days

[siva]

Hi All,

I would like to convert the duration into days... For example if i
have 56:32:48 (hrs:mm:ss), i would like to convert this into 2 days
8:32:48 or to any format which would describe this result. Thank you.

Cheers,sivaji

 

[Bernd P]

Hi All,

I would like to convert the duration into days... For example if i
have 56:32:48 (hrs:mm:ss), i would like to convert this into 2 days
8:32:48 or to any format which would describe this result. Thank you.

Cheers,sivaji

Hello,

=INT(A1)
will return number of days. You need to format this as number.

=MOD(A1,1)
will return the remainder.

Regards,
Bernd

 

[James Ravenswood]

Hi All,

I would like to convert the duration into days... For example if i
have 56:32:48 (hrs:mm:ss), i would like to convert this into 2 days
8:32:48 or to any format which would describe this result. Thank you.

Cheers,sivaji

An alternate approach is to simply change the format to:
d:hh:mm:ss
to display:
2:08:32:48

 

[Ron Rosenfeld]

An alternate approach is to simply change the format to:
d:hh:mm:ss
to display:
2:08:32:48

At least in 2007 and earlier, that will not work for more than 31
days.

 

[James Ravenswood]

At least in 2007 and earlier, that will not work for more than 31
days.

Facinating!
is there any way to enter 35.234567
and have display as:
35:02:57:47
just by formatting (that is without changing the underlying numerical
value) ?

 

[Ron Rosenfeld]

Facinating!
is there any way to enter 35.234567
and have display as:
35:02:57:47
just by formatting (that is without changing the underlying numerical
value) ?

Not that I am aware of.