Convert Hrs:MM:SS to number of days

  • Thread starter Thread starter siva
  • Start date Start date
S

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
 
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
Click to expand...

Hello,

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

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

Regards,
Bernd
 
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
Click to expand...

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.
Click to expand...

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) ?
 
Back
Top