I am trying to figure out the elapsed time for two date/time fields I am keeping track of. The process works well when I do this:
ElapsedTime =[delivered]-[released]
The field format is set to hh:nn:ss
Furthermore, it works when I group elapsed time for a given day of the week and sum up the numbers:
=Sum([delivered]-[released
])
Again, the field format is set to hh:nn:ss
HOWEVER, when I group elapssed time over a a week's worth of time and try to sum up the elapsed time, the numbers don't quite add up. I mean it works when I group by a day, so why not over a week. Could someone tell me if this is a formatting issue or something else I am not seeing!
Thank you and I look forward to your response!
HT
Start Free Trial
