Time calculation

[Billy B]

I am trying to convert seconds to hh:mm:ss
Below is what I have and it doesn't work. Any help is appreciated.

TTime: (([TSeconds]\3600) Mod 24)) & ":"&
((TSeconds] \ 60) Mod 60) & ":" &
(TSeconds] Mod 60)

 

[Duane Hookom]

Try this:
TTime: Format([TSeconds]/86400,"hh:nn:ss")