Time Values - Sum up

[Rajesh S]

Dear Team,

I have the total time worked by an employee in each & every day. Would like to arrive at the sum of all times.

Based on the sum, would like to divide it with his productivity to arrive at time taken per produce.

Need your help to solve it. Attached the sample file of one employee.

Regards

S Rajesh

 

[Somendra Misra]

Hi Rajesh,

In you D6 cell you have date + time, try deleting date and than use SUM function over the Working hour column. I think that will give you total time.

Regards,

 

[Mike H..]

Dear Team,

I have the total time worked by an employee in each & every day. Would like to arrive at the sum of all times.

Based on the sum, would like to divide it with his productivity to arrive at time taken per produce.

Need your help to solve it. Attached the sample file of one employee.

Regards

S Rajesh

Hi,

In addition when you sum the times you will need to format the SUM cell as

[hh]:mm

The square brackets stop the sum rolling over to zero after 24 hours.