Forum Discussion
time average in excel??
hi, im trying to average times in format hh:mm, for example 22:00 21:30 03:00 00:00 so i get average between the smallest and latest value? any help thanks
It very depends on context. Do you have hundreds of such times in sequence, when how to recognize is that same or next date. Or, in opposite, if we have only couple of times, 6:00 and 18:00 how do we know 6:00 is first time at the same date or later time on next date.
Hi, bassically i have 7 of these times and i need an average on that format hh:mm, those times are departure times starting with 18:00pm to next day 6:00am so any (hour: minutes) between this interval of time( and only inside this interval) , thanks a lot for help
- =MIN(IF(A1:A7>=(18/24),A1:A7,IF(A1:A7<=(6/24),A1:A7+1,"")))
=MAX(IF(A1:A7>=(18/24),A1:A7,IF(A1:A7<=(6/24),A1:A7+1,"")))
Make a mean of ithey i attached the workbook in wich actually i need that average truck departure time, i filled up on each day sheet a diffrent time departure and on the WTD sheet F column i need that average time , please have a look , thanks a lot
That could be
=AVERAGE( (INDEX(Sun!F:F, MATCH($D7&$E7,Sun!$D:$D&Sun!$E:$E,0))<6/24)+INDEX(Sun!F:F, MATCH($D7&$E7,Sun!$D:$D&Sun!$E:$E,0)), (INDEX(Mon!F:F, MATCH($D7&$E7,Mon!$D:$D&Mon!$E:$E,0))<6/24)+INDEX(Mon!F:F, MATCH($D7&$E7,Mon!$D:$D&Mon!$E:$E,0)), (INDEX(Tue!F:F, MATCH($D7&$E7,Tue!$D:$D&Tue!$E:$E,0))<6/24)+INDEX(Tue!F:F, MATCH($D7&$E7,Tue!$D:$D&Tue!$E:$E,0)), (INDEX(Wed!F:F, MATCH($D7&$E7,Wed!$D:$D&Wed!$E:$E,0))<6/24)+INDEX(Wed!F:F, MATCH($D7&$E7,Wed!$D:$D&Wed!$E:$E,0)), (INDEX(Thur!F:F, MATCH($D7&$E7,Thur!$D:$D&Thur!$E:$E,0))<6/24)+INDEX(Thur!F:F, MATCH($D7&$E7,Thur!$D:$D&Thur!$E:$E,0)), (INDEX(Fri!F:F, MATCH($D7&$E7,Fri!$D:$D&Fri!$E:$E,0))<6/24)+INDEX(Fri!F:F, MATCH($D7&$E7,Fri!$D:$D&Fri!$E:$E,0)) )
- Thanks a lot, let you know if it worked
When it depends on which version of Excel you are and what do you mean under "average". If Excel 365 and median, it could be
