excel hr total

[anand6802]

Hi Guys,

i need help on below Scenario

how to count total no of hrs in total hr cloum

which formula we should use for this matter please help me any expert in excel.
[TABLE="width: 372"]
<tbody>[TR]
[TD]training1[/TD]
[TD]training2[/TD]
[TD]training3[/TD]
[TD]training4[/TD]
[TD]Total hr[/TD]
[/TR]
[TR]
[TD]1 hr[/TD]
[TD]2hr[/TD]
[TD]30 min[/TD]
[TD]40 min[/TD]
[TD]4.10 min[/TD]
[/TR]
</tbody><colgroup><col span="3"><col span="2"></colgroup>[/TABLE]

 

[mole999]

well providing you put the values in as time and format your result as [h]:mm just add them up ++++

 

[anand6802]

Hi mole999

could you please explain me more

 

[My Aswer Is This]

You must enter your time values like shown below:
In row 1 for example beginning in column "A" to Column D enter the below values. Then in cell E1 enter the formula =sum(A1:D1)
In Cell E1 you must right click the cell choose format cell then choose number then choose custom select the line below Type back space over the existing values and paste in this [h]:mm
1:
2:
0:30
0:40
And that should do it.

 

[anand6802]

okies...

Thanks a lot my answe us this

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

okies...

Thanks a lot my answe us this