Forum Discussion
pq23or
Apr 08, 2021Copper Contributor
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
SergeiBaklan
Apr 08, 2021Diamond Contributor
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.
- pq23orApr 08, 2021Copper ContributorHi, 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
- MindreVetandeApr 08, 2021Iron Contributor=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 it- pq23orApr 08, 2021Copper Contributor
hey 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
- SergeiBaklanApr 08, 2021Diamond Contributor
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