Calculating Times

[tbaguio]

Is there a function out there that will allow me to accomplish the following in a report:

1) Calculate time elapsed from one time to another (both medium time formats) eg. [EndTime]-[StartTime]

2) Then take the outcome and add them all together to get a total elapsed time in hours and minutes. eg. SUM([EndTime]-[StartTime])

3) Then average that value out to get the average time elapsed for my report.

I'm now running into the problem where either I display the data as the double-precision, floating-point number or I'm reduced to using the short time format which keeps rolling over every time my total is greater than or equal to 24 hours.

Any clues?

Thanks,
Theresa "Sleep is the best meditation." - Dalai Lama

 

[LonnieJohnson]

There are some date functions in Access that will help you.

1. DateDiff to get the difference
2. DateAdd to tack time onto an existing time

Access has a great tutorial and examples of each.
ljprodev@yahoo.com
ProDev, MS Access Applications

http://www.galaxymall.com/software/PRODEV

 

[tbaguio]

Geez,

This is one of those things were you trying to do something the hard way... instead of the easy way that you didn't notice before. Thanks so much. I've been playing with custom functions all afternoon and neglected to even try those functions.

Worked like a charm. What's the expression.... I'm missing the forest for the trees....

Thanks... you saved me from a total brain purge.

Theresa

PS In case anyone searching this thread for information on creating custom time/date calculations.... see Microsoft's sample functions:

http://support.microsoft.com/support/kb/articles/Q88/6/57.ASP

"Sleep is the best meditation." - Dalai Lama