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...
HansVogelaar I can repro it by doing this in a cell:
This works
=TIME(,,32767)
This doesn't
=TIME(,,32768)
I am converting seconds to a time span. I am trying for 00:00:00 (h:mm:sec). The first one above works the second I get #NUM
Use =32768/86400 and format the result as dd:hh:mm:ss
(86400 is the number of sconds in a day)