convert hr:mm:ss into days hh mm ss

[goodboy]

Hi All,
In one cell A1 have 50120:14 in B1 I have 828 so in cell C1 I want to divide A1/B1 and so I need answer as 2 days 12 hrs 31 seconds.
Any help

Thanks in advance
Goodboy

[goodboy]

Suppose I have 53:48:50 in a cell how to show this as 2 days 5 hrs 48 minutes 50 seconds in corresponding cell.

Any help

[zbor]

Format cell as

Please Login or Register  to view this content.

[mnjofra]

hi goodboy,
can you explain me what means 50120:14 ?? I can not imagine what notification is it? 50120 minutes and 14 seconds, or 50120 hours and 14 minutes? Or what ???