Converting seconds to Hours, minuters,seconds

[wrburch]

I have a formula to calculate the difference in time by seconds, i.e 108,000. When I try to convert to time using crtimefromsecssincemidnight(@total time), I get the error "out-of-range(0-86400). Is the a way to give me the total time 30:00:00 hours?

Thanks, Bill B

 

[lbass]

You should show the content of your formula (and of any embedded formulas). You could also take a look at the FAQ by Synapsevampire--might be helpful.

-LB

 

[kray4660]

I have created custom formulas in the past to convert from seconds to hours:minutes:seconds in the past. I will have to see if I can find it. It was mostly a matter of division and subtracting off (i.e. subtracting off the whole hours in seconds from the total time).

 

[wrburch]

Thanks, the synapsevampire formula works

 

[AndyMc]

I think this is the FAQ that lbass recommended that wrburch used:
faq767-3543