Calculate weekly hours from a row

[Bucki]

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

 

[navic]

In the 'N6' cell try formula below

=(D6-C6)+(F6-E6)+(H6-G6)+(J6-I6)+(L6-K6)

Then, format cell Custom Time over 24 h

 

[Bucki]

In the 'N6' cell try formula below

=(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,