I am converting seconds to hh:mm:ss from seconds (CR2016)
I usually use the formula below which works fine for anything under 24 hours
CStr(CTime(currentfieldvalue/ 86400), "hh:mm:ss")
I have a few fields that go above 24 hours, so for 25:00:06 - this reads 01:00:06.
I have tried
CStr(CTime(currentfieldvalue/ 3600), "hh:mm:ss") - doesnt work
Any ideas on how this can be used for anything over 24 hours