Working hours average


Aviral Sharma

I have a database of a person's working hours where I have his three months
extra or less working hours. I want an average of all the three months.

Can someone help me with the formula for this average. Here the average
formula is not giving the correct value.

Month 1 Month 2 Month 3 Average
-08:31:00 -24:50:00 21:01:00 ?


Hi Aviral,

Assuming the data is there in columns A, B,C and D respectively, use
following formula in column D:-


Please click on "yes" if it works

Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question