Convert seconds to HH:MM:SS format

[sai_rlaf]

Hello. I have a create date field and a complete date field. I used a date diff function to find the elasped seconds from the two date and times. I want to have it displayed in a report showing Total # of hours minutes and seconds format HH:MM:SS. The number will excede a whole day at times so that is where I need to most help. ANy help provided is appreciated.

[orange]

For what it's worth - it's a start

60 sec =1 min
60 min = 1 hr
24 hr = 1 day

1 day = 84600 sec
1 hr = 3600 sec

Total seconds /84600 = Total days
Total seconds /3600 = Total Hours

Just googled

Try this http://www.access-programmers.co.uk/...ad.php?t=57023

[sai_rlaf]

That did it! THanks alot!