Calculate totals of hours listed in a column

Joey_R

Board Regular
Joined
Sep 7, 2004
Messages
123
Hi Guys,

I have a colum of figures which contain a breakdown of Hours worked by a group of people. The problem is I need to sum this column so I can calculate the total amount of hours worked by all employees.

Thanks
Jo
:(
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Joey_R

Board Regular
Joined
Sep 7, 2004
Messages
123
Hi Colin

Thank you - It seems to have done the trick. However:

Please could you explain your answer. I do not understand the [h]:mm format.

Thanks
Jo
:p
 

rs2k

Well-known Member
Joined
Aug 15, 2004
Messages
1,413
I cant give you a full explaination, because I don't know myself. however, when you total time up excel goes upto 23:59 then onto the next day by default, so if you add two minutes to 23:59 excel would come back with 00:01. By using the [h] format it just keeps totaling up. Maybe one of the gurus out there can explain better, I will be keeping an eye on this post for a better answer.

Cheer's
Colin.
 

Forum statistics

Threads
1,148,272
Messages
5,745,790
Members
423,973
Latest member
man_this_is_hard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top