# converting a number into days:hours:minutes

#### ToffaJ

##### New Member
Heres a doozey...

Does anyone know how to convert a straight number into days:hours:minutes. So if you have a number that is say.. 1269859... which are seconds, how can you convert that into days and so on... what is the formula for the cell format???

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Divide by 86400 to get decimal days (60 *60 *24).

To get elapsed hours use the format [h]:mm:ss.

I do not know a format for elapsed days:hours:minutes, but this formula works:

=INT(A1/86400)&" "&TEXT(A1/86400-INT(A1/86400),"hh:mm:ss")

This returns a text string not a value, so you will not be able to use it in other calculations.

Replies
7
Views
122
Replies
8
Views
144
Replies
6
Views
195
Replies
4
Views
119
Replies
3
Views
208

### Forum statistics

1,203,489
Messages
6,055,722
Members
444,814
Latest member
AutomateDifficulty

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back