Calculating Elapsed Minutes

[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?

 

[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.