Forum Discussion
Solved
Error #NUM when converting decimal to dd:hh:mm:ss
I am trying to convert a decimal to dd:hh:mm:ss format but get an #NUM error. It works until I hit an upper limit. I figure out the issue but don't know how to fix it. When I convert a decim...
Getting closer, but maybe just a bit more explanation will help. And it may be the =TIME formula is not the right use here.
My situation is I have a number in seconds, and it may range from a low number of 30 to 40 seconds but can also get in the multiple hour ranges of tens of thousands of seconds.
So regardless of the number of seconds I just want to display that in 00:00:00:00 format.
I can probably write my own formula and concatenate the result, but that seems overkill.
Thanks for all the feedback so far.
My situation is I have a number in seconds, and it may range from a low number of 30 to 40 seconds but can also get in the multiple hour ranges of tens of thousands of seconds.
So regardless of the number of seconds I just want to display that in 00:00:00:00 format.
I can probably write my own formula and concatenate the result, but that seems overkill.
Thanks for all the feedback so far.
- I think I was making it harder than it needed to be. Thanks.