Averge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having the difficult of Averge of Time.
I have 2 column,
SumOfCases TotalTime
9 4:05
and my fomual is =Str(Avg([Minutes])\(Sum([CountOfCase_Status]))) , it
doesn't work. I don't know how to do that. Thank you for your help.
 
Time is typically used for a particular point in time (it is 12:45).
DURATION is used to express how long something took (it took 12 hours and 45
minutes). To perform math on a DURATION it needs to be stored as a number.
In your example, I would expect to see 4.08333 or similar.

What type of field is "TotalTime" in your table? If it is a Date/Time
field, then you need to change it.
 
Back
Top