How can I change decimal time to days hr min

[Marie Hall]

Hope someone there could help me. I'm relatively new in Access and have a problem. I Have a Date/Time Out for equipment and a Date/Time Back for equipment. My Query calculates as:

Example:(2/17/09 12:00:00 PM)-(2/6/2009 12:00:00 PM)
Answer:11...in days
Example:(1/5/09 1:30:00 PM)-(5/18/09 1:00:00 PM)
Answer:132.979166666664
How can I change this into 132 days .5 hrs/or 30minutes

Example:(2/17/2009 09:45:00 AM)-(2/17/2009 09:00:00 AM)
Answer:0.03125
How can this be changed to .45/or .75
What formula do I use and when do I enter it.

[NeoPa]

Any value in days can easily be converted to hours by the simple expedient of multiplying it by 24.

[Marie Hall]

In my query:
DateTime_Calculation: ([DateTime_In:]-[DateTime_Out:])
Where do I multiply by 24. DO I open a new field? Do I make a new query? Do I multiply total on the Text box on of the FORM? I don't have any experience and am grasping at straws... Please help

[NeoPa]

Try :

DateTime_Calculation: ([DateTime_In:]-[DateTime_Out:]) * 24

[Marie Hall]

([5/18/2009 1:00:00 PM]-[1/5/2009 1:30:00PM])*24 Answer went from 132.979166666664 to 3191.49999999994 not into 132 days and .50 / or .30 minutes Ghee I wish I knew what I was doing? Was I suppose to add *24 to query calculation? Sorry If I sound desperate but I've been on this problem for a WHILE

[NeoPa]

Ah. I think I have a better idea now what you were trying to ask for :-
The whole number of days then the fraction displayed as hours etc.

That's not so easy as the days and hours etc would need to be done quite separately. Here's what I have for the whole caboodle. You can work out exactly what you need from there :

DateTime_Calculation: Int([DateTime_In:]-[DateTime_Out:]) & Format([DateTime_In:]-[DateTime_Out:], " \Da\y\s H \hour\s, m \mi\nute\s, ss \se\co\n\d\s")

[Marie Hall]

Oh I can't believe it finally works. It's been a long process on getting this to work. You have really taught me a real lesson in how a query works....Thanks,Thanks, Thanks so much.....

[NeoPa]

It's a pleasure Marie.

It's also a very good indicator for future questions about how important it is to get the question right and clear in the first instance. I doubt you'd have experienced the delays if the question had been clearly understood from the start. We see this a lot, where people struggle for answers, even when many of us have them, simply because the question isn't recognised for what the questionner is trying to ask.