Duration Format

[InternBoy]

Here's my problem...

I have gathered 1000+ entrees from a connectivity report generated by my logs. It gives me the duration of the sessions in seconds. I need to change the format to hour,minutes, seconds. Please HELP!!!

Examples:

7200 seconds = 02:00:00

38830 seconds = 10:47:10

[tlsparker]

Assuming the name of your field containing seconds is "Sec" , create a calc field:

SecondsToTime = Time(0,0,Secs)

make sure the result of the calculation is set to "Time"

This will give you your desired result.

Tom