ExcelBanter - TOTAL AND AVARAGE

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - TOTAL AND AVARAGE (https://www.excelbanter.com/excel-worksheet-functions/236186-total-avarage.html)

TOTAL AND AVARAGE

HI,
I have a problem, that is given below, pl help any one:-

DD:HH:MM:SS These timeings are, time taken to compleat the each work
01:04:20:10 so, my requirement is, total time taken to compleat the
works,
00:18:45:20 and avarage time per work.
01:12:15:00
02:02:20:45
----------------
Total
Regards
gv

TOTAL AND AVARAGE

Would suggest you maintain the time recording in either time or date&time for
easy calculations. From menu FormatCellsCustomType

[h]:mm:ss

If you maintain time recording in this format..you can use the normal
formulas SUM() and AVERAGE()

If this post helps click Yes
---------------
Jacob Skaria

"raogv" wrote:

HI,
I have a problem, that is given below, pl help any one:-

DD:HH:MM:SS These timeings are, time taken to compleat the each work
01:04:20:10 so, my requirement is, total time taken to compleat the
works,
00:18:45:20 and avarage time per work.
01:12:15:00
02:02:20:45
----------------
Total
Regards
gv