Convert minutes to hour and minute in MS Access 2000.

Hello,

In my Access report, I have a minutes field in the detail line. How
do I convert that minute to hour and minute. The problem for me now
is if I take the minutes, say 75 divide by 60, it gives me 1.25; or
90/60 = 1.50. These are not what the user wants.

They want to have hour and minutes, say 75 minutes, needs to convert
to 1.15 (1 hour 15 minutes); or 90 minutes to 1.30, and so on.

Are there any easy way to do it? Thanks in advance,

James

Use Integer division to get the whole hours, and Mod to get the left over
minutes:
=[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"James P." <hanoi_honai@yahoo.com> wrote in message
news:f49d1d72.0408172133.3f61f470@posting.google.c om...[color=blue]
> Hello,
>
> In my Access report, I have a minutes field in the detail line. How
> do I convert that minute to hour and minute. The problem for me now
> is if I take the minutes, say 75 divide by 60, it gives me 1.25; or
> 90/60 = 1.50. These are not what the user wants.
>
> They want to have hour and minutes, say 75 minutes, needs to convert
> to 1.15 (1 hour 15 minutes); or 90 minutes to 1.30, and so on.
>
> Are there any easy way to do it? Thanks in advance,
>
> James[/color]

"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message news:<4122eb22$0$17534$5a62ac22@per-qv1-newsreader-01.iinet.net.au>...[color=blue]
> Use Integer division to get the whole hours, and Mod to get the left over
> minutes:
> =[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00")
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "James P." <hanoi_honai@yahoo.com> wrote in message
> news:f49d1d72.0408172133.3f61f470@posting.google.c om...[color=green]
> > Hello,
> >
> > In my Access report, I have a minutes field in the detail line. How
> > do I convert that minute to hour and minute. The problem for me now
> > is if I take the minutes, say 75 divide by 60, it gives me 1.25; or
> > 90/60 = 1.50. These are not what the user wants.
> >
> > They want to have hour and minutes, say 75 minutes, needs to convert
> > to 1.15 (1 hour 15 minutes); or 90 minutes to 1.30, and so on.
> >
> > Are there any easy way to do it? Thanks in advance,
> >
> > James[/color][/color]

Thank you very much, Allen. It works like a champ!

James