Ok. I have this query that is working out okay. However, I need a way to convert the answer it gives me from minutes to total hours. When I simply divide by 60 it gives me the number as a percentage of the hour in decimal form. I need the actual hours, for example if the total times of lab work ended up being 108 minutes, I want the field to show 1:48 for one hour and 48 minutes.
am attaching an example in a word doc for graphical reference
Thanks a bunch...(if it ain't one thing it's another) :)
Minutes to hour conversion in query or report
-
- 2StarLounger
- Posts: 170
- Joined: 05 Feb 2010, 18:04
- Location: Jacksonville, NC
Minutes to hour conversion in query or report
You do not have the required permissions to view the files attached to this post.
If you can't convince them, confuse them - Harry S. Truman
Nannette
Nannette
-
- Administrator
- Posts: 78484
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Minutes to hour conversion in query or report
Welcome to Eileen's Lounge!
Instead of dividing by 60, divide by 1440 (the number of minutes in a day) and format the result as h:mm
Instead of dividing by 60, divide by 1440 (the number of minutes in a day) and format the result as h:mm
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 170
- Joined: 05 Feb 2010, 18:04
- Location: Jacksonville, NC
Re: Minutes to hour conversion in query or report
Hi Hans. Thank you for the welcome.
Thank you.!!! Good to see you all again. I have a new home. :)
Thank you.!!! Good to see you all again. I have a new home. :)
If you can't convince them, confuse them - Harry S. Truman
Nannette
Nannette
-
- Administrator
- Posts: 78484
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Minutes to hour conversion in query or report
You have to set the Format property of the text box to h:mm
That tells Access that you want the result to be formatted as a time value instead of a number.
That tells Access that you want the result to be formatted as a time value instead of a number.
Best wishes,
Hans
Hans