total Minutes to Hours:minutes on report

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I have a report that groups on several items. Each of the
group footers needs to convert the total number of minutes
to Hours:minutes. I can't change the datatype of the
field which is long integer. I have tried using the
calculated text box for total minutes in several
conversions but have been unsuccessful. When I generate
the report, it brings up the box wanting me to put in a
parameter value. Any help would be appreciated.

Int([grp5_hours)/60) & ":" & ([grp5_hours])-Int
([grp5_hours])/60)*60

[grp5_hours] = is the calcuated field in the group footer,
that references back to the field name [hours]

thanks
 
Brian said:
I have a report that groups on several items. Each of the
group footers needs to convert the total number of minutes
to Hours:minutes. I can't change the datatype of the
field which is long integer. I have tried using the
calculated text box for total minutes in several
conversions but have been unsuccessful. When I generate
the report, it brings up the box wanting me to put in a
parameter value. Any help would be appreciated.

Int([grp5_hours)/60) & ":" & ([grp5_hours])-Int
([grp5_hours])/60)*60

[grp5_hours] = is the calcuated field in the group footer,
that references back to the field name [hours]
Click to expand...


Did you forget the = sign in front of your expression?

Unless you misspelled something (or the missing ] is not a
posting typo), your expression looks like it should work,
but it would be better to use:

=[grp5_hours] \ 60 & Format([grp5_hours] Mod 60, "\:00")
 
Back
Top