How to convert seconds to hh:mm?

[ddtpmyra]

Help! I have value of a field in seconds. I know is how to get the minutes by dividing it to 3600. But I wanted to display it in HH:mm.

given number for seconds is 8111

[ddtpmyra]

what's wrong with this?

AcdCallsDuration: Format(([DAgent]![AcdCallsDuration]\60) Mod 60,":00") & Format([Dagent]![AcdCallsDuration]>"Mod 60",":00")

[beacon]

Try this out:

Format([YourFieldHere]/3600, "hh:nn")

[ddtpmyra]

I think this will simplify my code. However how can I sum the final result?

Format(([YourField]/3600),"hh:nn:ss")

[ddtpmyra]

Im having data type mismatch error if I sum the time HH:NN.

[yarbrough40]

looks as though you are looking at call center data (acd). I had a similar problem displaying call duration for a call center with a .net app. Tryed to replicate the excel function [h]:mm:ss.
here was my solution - not sure if it helps you or not.

http://bytes.com/topic/visual-basic-net/answers/870771-vb-function-convert-decimal-elapsed-time-h-mm-ss-like-excel

[beacon]

Have you tried to sum the time(s) while still in seconds, then format it to hh:mm afterwards?

[ddtpmyra]

@Beacon

I tried it but after I got 00:00:00 result value.

[beacon]

Ok...how did you try it? Can you give an example of the data you're using, the function/expression you used to add the items together, and describe how you tried to convert it?

[whodgson]

To get minutes divide seconds by 60
To get hours divide seconds by 3600
8111 /3600 = 2.253055556 ....2HH
.253055556*60=1 5.18mm