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