Converting decimal value to hh:mm:ss

[dezenzerrick]

Hi all,

I have a database that tracks the amount of time an employee has trained on something.


When I run a report, the total training time for all employees is summed in minutes.

It will display like
Total Time: =Sum([Minutes]) where [Minutes] is what was entered for each employee.

The issue is that the data is in a decimal format. When the time is entered it is like so:

Time (minutes): 5.45, where .45 is (.45*60) seconds, or 27 seconds.

So, when the time is summed, it comes up as 5.45+etc etc etc...
I know in Excel you can use =TIME(0,INT(A1),MOD(A1,1)*60) to convert a decimal to time, but I can't figure out how to do this in Access.

The time is displayed in a text box, and the function uses "=Sum[(Minutes)]" as the control source.

I am trying to use the expression builder for this. Should VBA be used?

[dezenzerrick]

Update: I figured out a way, nevermind.