Converting Seconds to Hours and Minutes

[kirklandmeyers]

I am having trouble converting seconds to hours:minutes:seconds. Does anyone know how to calculate this and save it as a duration in a time format? For example, how to convert 200 seconds to 00:03:20 or 4000 seconds to 01:06:40. Thanks for any help that can be offered. I really appreciate it as I am in a bind.

Kirk

[EddyB]

Hi Kirk

Create a new calculation field - time

In the calculation all you need to enter is your field containing seconds

So time=seconds

Then make sure that the calculation result is time.

Hope this helps

Ed.

[kirklandmeyers]

Thanks Ed. I can't believe how simple that was. Thanks again!!!

[EddyB]

No probs!

Happy to help

Ed.