I’m sorry for bothering you a lot with this file
Hopefully it’ll be the last time
Referring to “Staff Members Performance” sheet
I’m trying to find the average
With the formula I’m supposed to get 15 minutes (or 0:15), not the value displayed on D6
I’ve tried another way which is transferring the time values of G column first to minutes by multiplying with 1440, however this is not working for the nature of the generated report of the system which is generating the timing with the date 1/1/1970 (kindly check sheet “1”)
What I could do with this please?
Time Average Calculation
- Thread is marked as Resolved.
Well, I'm afraid the formula isn't that accurate
you see, it's supposed to end up with 15 minutes
you got 37 minutes
See your attached file ...
Hope this will help
Yeah, this works perfectly
last request though
any idea how to convert the format to be 0:15, not just 15?
Yeah, that's perfect
thanks a million
Glad you have managed to completely sort it out ...:wink:
Thanks a lot ... for your Thanks ... AND for the Like ..:smile:
Why do you keep posting in the VBA section? There is a forum section called Excel Formulas where you should be posting.
Don’t have an account yet? Register yourself now and be a part of our community!