How to convert whole numbers into seconds then amounts of time?

[Anonymous]

I have a table that contains seconds of time for calls but it is as whole numbers as below.  I am trying to convert this into quantity of time like hours:minutes:seconds

Data stored:

7635

31

9690

Would like to convert to:

7635   = 2:07:15 

31      = 00:00:31

9690   = 2:41:30

Thank for the help.

[tresesco · Accepted solution]

=Time(Time#('9690','ss'),'hh:mm:ss') ---------2:41:30

[Anonymous]

Don't you just love when you ask a question and 30 seconds later you find the answer you were looking for.

=interval(interval#(sum(FieldName),'ss'),'d hh:mm:ss')

[Anonymous]

Tres, thanks for the extremely quick response.  I see as always, there are many ways to skin a cat.