Format Time [Resolved]

[RobDog888]

I need to format a serial time duration into "HH:MM"SS".
The time is from a stored procedure that returns the duration
that the user is logged in, but I'm not sure on the measure of
time SQL uses. It looks like miliseconds. I guess I need something
like the reverse of TimeSerial function.

Ex.
77984 = ??? hours, minutes, or seconds?

Is there an easy way to do this formatting?

Thanks.