My example is that I have 2038 total reports. I want to find out the average amount of time it took to read each reports based on a total time of 1.08:11:21
It seems like I would need to convert the time to minutes, but haven't been successful in doing that through Excel yet (I'd rather not do it on my own outside of Excel). Is there a formula that can do this based on the columns and numbers I have now without having to break this down?
I tried just a simple =a1/b1 and that didn't work.
Bookmarks