Calculating Elapsed Minutes

B

bonehead

A friend tells me that he has not been able to work out an expression
that calculates elapsed minutes from TimeA to TimeB.

For example:

TIMEA TIMEB ELAPASED
----- ----- --------
11:30AM 12:35PM 65

Suggestions?
 
J

John Spencer (MVP)

Use the DateDiff function.

DateDiff("n",TimeA,TimeB)

Note that this will fail (return negative numbers) if you cross days unless you
include the date along with the time.
 
Top