Subtracting Times...

[QMDirk]

Hi again. Does anyone have a simple code to subtract one Time from another and display the result in Minutes? Ex: [Time Up]-[Time Down]=[Total Minutes]

 

[bob fitz]

You need to use the DateDiff() function. See: https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/datediff-function

Post back if you're still stuck after reading about it.

 

[QMDirk]

You need to use the DateDiff() function. See: https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/datediff-function

Post back if you're still stuck after reading about it.

Yes, but where, please? The last explaination wasn't clear about where to insert the DateDiff() code...

 

[namliam]

In your query , form or report where ever you need this.

 

[QMDirk]

I see. To this day, I have never successfully used a Function in VBA to do anything. Web pages don't answer all of my questions and I'm left hanging. I understand what the function is trying to do, I just have no idea where to put it.

 

[missinglinq]

Yes, but where, please? The last explaination wasn't clear about where to insert the DateDiff() code...

And your original post said nothing about where you need it to go! As the Mailman said, it needs to go wherever you need it to go.

Perhaps a plain language explanation of exactly what you're trying to do would help us to help you.

Linq ;0)>

 

[bob fitz]

I see. To this day, I have never successfully used a Function in VBA to do anything. Web pages don't answer all of my questions and I'm left hanging. I understand what the function is trying to do, I just have no idea where to put it.

Use in a query as a calculated field. Something like:
Answer: DLookup()etc

Or as the Control source property of a textbox on a form. Something like:
=DLookup()etc

 

[Uncle Gizmo]

Web pages don't answer all of my questions and I'm left hanging.

I know exactly what you mean, it's a long time since I started learning MS Access, and I do remember it being quite difficult. However, as I've got more proficient, I find it easy, and then when I see someone ask a question I immediately know the answer, and sometimes I wonder why people don't know. Now, that was until recently, until I started learning a new programming language from scratch myself! It's an absolute nightmare, the simplest things are beyond me, and to get the information, to find the answer is so convoluted and laborious. I feel for you! I hope you find my Nifty Access website useful. I try and address things in a simpler manner than most, to cater for people who are trying their best to learn!

Add Time to a Date - Nifty Access

I've put together a few videos over the years on the date/time issues in Microsoft Access. If you would like a bit more background information on the date/time issues see my website here:-

Time Gentlemen Please - Nifty Access

Time Gentlemen Please Using Date and Time in MS Access can be a bit of a minefield, so I suggest you do plenty of research on it. I've done a few video's on Date/Time over the last few years and I've brought them together in this post More Links in the DATE MENU Below! Add

www.niftyaccess.com

 

[Uncle Gizmo]

To follow on from my video about date and time. I want to draw your attention to a warning from Daniel Pineault about directly adding and subtracting from/to dates. See his excellent video:-

Big thanks to Nautical Gent @NauticalGent for pointing out the video!