Converting Minutes from a Query to Hours:Minutes on a Report

[Nuke1096]

Basically I have a table setup where Time Fields are stored. What I need to do is in a Query, have the difference of two Time Fields calculated, and then displayed on a Report. Here's what I have so far...




Table

- Start Time
- End Time


Query

Difference Time: DateDiff("n",[Start Time],[End Time])



All that works fine and shows up on the report, except for the fact that the time is showed in straight minutes, so for a difference of 1:30 minutes, it just shows 90 minutes. I need to make it so that on the report in the Difference Time Text Box, it's showed as 1:30 instead of 90.

I tried putting the following in the Control Source for the Difference Time Text Box on the report, but it returns an error. I'm not quite sure what I'm doing wrong.

=[Difference Time] \ 60 & Format([Difference Time] Mod 60, "\:00")

[rpeare]

TimeDiff: Right("00" & Int(DateDiff("n",[starttime],[endtime])/60),2) & ":" & DateDiff("n",[starttime],[endtime]) Mod 60

[pbaldy]

Try

=Int([Difference Time]/60) & ":" & Format([Difference Time] Mod 60,"00")

[Nuke1096]

Thanks guys.

It turns out that..

=[Difference Time] \ 60 & Format([Difference Time] Mod 60, "\:00")

...actually worked fine. The problem was that Difference Time was the same name as my Text Box, which is why I was getting that error. However, I am wondering what the advantages or disadvantages of using your examples instead of the above are?

[pbaldy]

Your way is fine; I forget about the backslash method of getting the integer.