Calculate time

[DougAtAvalon]

I read thru some treads but still can'tome up the answer. i am trying to come up with a calualation of time. i at least am trying to get the difference like the number 5 in this example.

For Example:
Text Box1: 3:50 PM (Medium Time Format)
Text Box1: 3:55 PM(Medium Time Format)
Total Hours:

Then a button to calculate. This is not the code but i can't get nothin to work.
------------------
Sub On click
Dim vStart
Dim vEnd
Dim vTotalMinutes

vTotalMinutes = vEnd - vStart
...etc. to get hours
End Sub
---------------


-Doug

 

[Nancy2]

DateDiff("n", start, end)

"n" returns the minutes

 

[MichaelRed]

Nancy is ccorrect -up to a point. The function will calculate the minutes, however as soon as the results exceeds one hour the results will not look like a "time" (if it ever did). You should carefully consider who will use the results and in what context, as some formatting may be useful of necessary.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over