Originally Posted by

**CdCf**
I know of one way to sum up time pretty easily.

Let's say you enter time as a decimal number (ignore seconds, or round off to nearest minute) in each cell, in column G (in this example - change as needed).

Then add another column, where you enter:

=INT(G4)+((G4-INT(E4))*100/60)

So, column G, with a time entry of 12 hours and 40 minutes, entered as 12.40, will convert to 12.67 in the column with my formula. And that time format will sum up nicely at the end of the sheet.

A backwards operation can then be added to convert the summed time to hours and minutes. Let's say the column with the above formula is column K, and the rows range from 1 to 50, then:

=((SUM(K1:K50)-INT(SUM(K1:K50)))*60/100)+INT(SUM(K1:K50))

This formula will change a decimal time back to an hours and minutes time (although still as a decimal number!!!).

Modify as required.

If you don't get it, just ask.