I am not sure if this has been asked before.
What would be the Numbers formula for converting HH:MM:SS to DD:HH:MM:SS? The Excel formula is entering 396:59:45 into a cell and then in another cell is the following =TEXT(A2,"dd:hh:mm:ss"). The A2 is the example cell.
iPod touch (5th generation), iOS 8.1
Numbers for iOS doesn't have a TEXT conversion for that as such, but still relatively easy to accomplish. Set the formatting for the second (destination) cell to proper duration (You will need to use the slider to adjust to Day HR Sec). Then add a simple formula to it =A2 to use your example. An actual conversion formula isn't needed.
An update to what I'd like.
A1= Star Trek The Original Series
A2= 68:37:03
A3= Blank
A4= Star Trek The Next Generation
A5= 134:44:05
A6= Blank
A7= A2 & A5 total in HH:MM:SS format
A8= A2 & A5 total but in DD:HH:MM:SS format
Just wondering what the formula would be to get it in DD:HH:MM:SS format.
There is no formula to actually do the conversion. It is a matter setting the cell format. After that all you need to do is add a simple =<cell> formula to get the value in (i.e. - see my previous post), or a formula to add the two values (=A2+A5). Use Duration rather then Time for the cell formats.
A duration in Numbers for iOS will not appear 10:16:25:03, it will display as 10d 16h 25m 03s. If it is the actual display punctuation you are trying to change, it may be possible using a combination of a Duration and TEXT functions but would be quite lengthy, convoluted, and more trouble than it is worth.
Just to be clear, Excel does NOT provide a Duration cell formatting. If you have something entered as 10:16:25:03, for example, it is either simply text, or it is actually a Time format (which also includes a Date, even if you are not displaying it). Using the Duration format in Numbers would be a far easier method of achieving what you are looking for, with no need to use a TEXT formula to convert anything.
Numbers Equivalent of Excel Formula for Converting HH:MM:SS to DD:HH:MM:SS
