P
Pam
My customer received a file with columns listing times that represent how
long it took to do something. Example:
88:56:55 (88 hours, 56 minutes, 55 seconds). The problem is that the actual
formatting of the cell is a custom format of:
[>=0.0416666666666666][h]:mm:ss;[m]:ss (Yikes!)
What I need is to have the cell actually contain: 88:56:55. I am able to do
the formula: =text(A1,"mm:ss") to get the 56:55 to show up. But if I do:
=text(A1,"hh:mm:ss") I get 16:56:55. (It's working on a 24 hour clock for
hours I guess and so I don't get the entire 88 hours that I want.)
Any ideas would be greatly appreciated.
long it took to do something. Example:
88:56:55 (88 hours, 56 minutes, 55 seconds). The problem is that the actual
formatting of the cell is a custom format of:
[>=0.0416666666666666][h]:mm:ss;[m]:ss (Yikes!)
What I need is to have the cell actually contain: 88:56:55. I am able to do
the formula: =text(A1,"mm:ss") to get the 56:55 to show up. But if I do:
=text(A1,"hh:mm:ss") I get 16:56:55. (It's working on a 24 hour clock for
hours I guess and so I don't get the entire 88 hours that I want.)
Any ideas would be greatly appreciated.