Calculate weekly hours from a row

Bucki

New Member
Joined
Mar 4, 2010
Messages
46
Dear All,

I have a spreadsheet with the Start | End times for each day, split accross the table (a row).
Now, I like to add at the end of the row the total worked hours.

Is this possible to have a calculation in one single column?
Other option would be have a seperate calculation for each day =sum(D6-C6) and then add up all those rows.

FYI: the columns have a custom format cell of hh:mm
1604653468106.png
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Bucki

New Member
Joined
Mar 4, 2010
Messages
46
In the 'N6' cell try formula below
Code:
=(D6-C6)+(F6-E6)+(H6-G6)+(J6-I6)+(L6-K6)
Then, format cell Custom Time over 24 h
Thank you :) it worked out.

I didnt know that changing the format cell to 24h will make it work.
I knocked myself out with the =(D6-C6)+(F6-E6)+(H6-G6)+(J6-I6)+(L6-K6) and was showing 17:00:00 lol


Cheers,
 

Watch MrExcel Video

Forum statistics

Threads
1,129,479
Messages
5,636,575
Members
416,925
Latest member
malamutus

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