Converting Minutes Into Hours

[KellyM]

One of my fields is Minute. I am creating a report and the minutes will be in the Detail section of the report. For group footer, I would like to sum up all minutes spent working on a project but I want to display it as hours and minutes instead of just minutes. For exampe, for 90 minutes, I want it to display as 1 hour 30 minutes. How do I convert the minutes into hours?

[jzwp11]

Something like this should work

int(yourfield/60) & " hours " & yourfield-(60*(Int(yourfield/60))) & " minutes"

[RagJose]

I would just add to jzwp11's answer suggesting using "sum(yourfield)" instead of just "yourfield", so it would add all the occurrences before the group footer.

[KellyM]

Thanks! Where do I place that code in my report?

[pbaldy]

I'd simply the minutes calculation with the Mod operator:

?int(255/60) & " hours " & 255 Mod 60 & " minutes"
4 hours 15 minutes

[RagJose]

Thanks! Where do I place that code in my report?

As the ControlSource of a control you must create in your group footer to show the total time.

[jzwp11]

Assuming that you already have a control for your sum (in minutes), I would just add a new textbox in the same location with the expression (mine or Paul's) and reference your sum control name in place of the "yourfield" in my expression.

[KellyM]

Thanks - that worked perfectly!

[jzwp11]

You're welcome. Good luck with your project.