Reports Help

[testsubjec]

Hi,

I have a standard query which feeds a report. The report show date of a call, description, and total time used between two specified dates for a specific room.
The Total Time Used column simply shows the time in whole minutes and what I need to do is change this so that 130 minutes would show 2 hours 10 minutes instead of 130.

Also what I would like to do is do a total a the bottom of the report showing a complete total of the Time Used in minutes and hours.

Thanks

 

[pbaldy]

This get you started?

?int(130/60)
2
?130 mod 60
10

 

[BRABUS]

how did you create the data in the Total Time Used column

This may point us in the direction to help shwo you an answer

 

[testsubjec]

The data in the Total Time used is a integer field in the database and is automatically updated by the telephone system we have.

 

[pbaldy]

Did you get the issue resolved?

 

[JANR]

You could do a function call on your total time field, something like this:

Public Function fTime(gTime As Variant) As Variant
    fTime = Format((gTime \ 60) Mod 60, "0") & Format(gTime Mod 60, "\:00")
End Function

you call it in your report:

=fTime([yourTotaltime])

JR