Calculating time elapsed?

  • Thread starter Thread starter Kerman
  • Start date Start date
K

Kerman

How would I determine the difference between time entered? I have a "time"
field where the time is automatically entered. Example: 10:00am to
11:05am I need to know the difference which is 1 hour and 5 minutes. Any
ideas?...Thanks...Randy
 
Kerman,

EndTime - StartTime = ElapsedTime

11:05am - 10:00am = 0.0451389 This is the fraction of a day answer.
If you now multiply this by 1440 (The number of minutes in a day) you get
the number of Minutes elapsed.

0.0451389 * 24 = 1.083333 Hours.
OR
0.0451389 * 1440 = 65 Minutes.
OR
0.0451389 * 86400 = 3900 Seconds.
 
Back
Top