TOTAL AND AVARAGE

R

raogv

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
 
J

Jacob Skaria

Would suggest you maintain the time recording in either time or date&time for
easy calculations. From menu Format>Cells>Custom>Type

[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
 

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

Similar Threads

AVARAGE TIME 1
Sum amounts based on date field 6
15 minute data to daily data 1
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Identify part number in list and tag it with characters from another list 4
Problem formatting dates from CSV file 2
Wage Calculator Q 1
time_report_date-wise_employee-wise 6

Top