Hi there,
I have a simple formula which calculates a team's overall average (using their daily time finished)
=AVERAGE(D8:AA8)
However, one of the times from a certain day goes past midnight (Ex. 1:00AM) and this number improves the average and makes it seem earlier, when it should be in fact later.
How do I solve this?
Thanks!
Bookmarks