How to sum the total time hrs

[asksign]

Hi,

I have the total hours like mentioned below and i need to sum and find out the total hours taken, can anyone help me on this?

Total Hrs

04:00

07:00

03:00

01:30

02:00

10:00

02:00

02:00

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[AliGW]

Deleted content.

 

[Aladin Akyurek]

Like this:

=SUM(A2:A9)

Custom format the formula cell as:

[h]:mm

 

[asksign]

I can't understand

 

[Aladin Akyurek]

I can't understand

Are you responding to post #3? If so, what is not clear?

 

[asksign]

Hi Aladin,

Its working, Thankyou..,

 

[asksign]

Hi Aladin,

I have replied to post #2.

 

[Aladin Akyurek]

Hi Aladin,

Its working, Thankyou..,

You are welcome.