Quote:
Originally Posted by Smurfy
OK ... but now of course my avg is not right ...
an avg time between 23:30 & 00:04 results in 10:20
actually swapping the min/max won't work either ... it throws those off if the times end up all before or after midnight
uhg ...
|
Any chance you could post an example workbook with dummy data?
I'm not sure I'm understanding how you get to "23:30 & 00:04 results in 10:20"