Calculating Elapsed Minutes

  • Thread starter Thread starter bonehead
  • Start date Start date
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?
 
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.
 
Back
Top