Calculating time difference

[Cardian]

I am rusty with Access and want to calculate the total time of an event. For
instance, if an event starts at 8:00 am and ends at 11:15 am, I want the
calculation to show 3 hrs, 15 min.

Is there a way to do this?

Thanks!

 

[guy.jara]

I am rusty with Access and want to calculate the total time of an event. For
instance, if an event starts at 8:00 am and ends at 11:15 am, I want the
calculation to show 3 hrs, 15 min.

Is there a way to do this?

Thanks!

Cardian,

Check out the "DateDiff" function. That should give you what you need.

 

[pietlinden]

I am rusty with Access and want to calculate the total time of an event. For
instance, if an event starts at 8:00 am and ends at 11:15 am, I want the
calculation to show 3 hrs, 15 min.

Is there a way to do this?

Thanks!

write a function to format it for you.

use DateDiff("n",StartTime,StopTime)
and then use integer division to get hours and then use MOD 60 to get
minutes. then format all that junk.