# Calculate weekly hours from a row

#### Bucki

##### New Member
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

### Excel Facts

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

#### navic

##### Active Member
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

#### Bucki

##### New Member
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,

Replies
0
Views
81
Replies
0
Views
167
Replies
0
Views
216
Replies
10
Views
83
Replies
8
Views
105

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.

### Which adblocker are you using?

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

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