making times work

[appletonthecat]

Hey People,

i am going around in circles and cannot seem to make this simple formula work

I have attached a copy of the table

I am trying to make a rota with the start time, finish time for each day add up to hours worked at the end of the week 

I have formatted the cells to time , used this formula =IF(E5<D5, E5+1, E5)-D5 tried CHat gpt and it just keeps giving me no results so any help right now is welcome 

cheers

dave

[#2 · Accepted solution]

@appletonthecat 

On the fly a nested solution.

Formula in English:

=SUM(IF(E5<D5,((E5+1)-D5)*24,(E5-D5)*24),IF(G5<F5,((G5+1)-F5)*24,(G5-F5)*24),IF(I5<H5,((I5+1)-H5)*24,(I5-H5)*24),IF(K5<J5,((K5+1)-J5)*24,(K5-J5)*24),IF(M5<L5,((M5+1)-L5)*24,(M5-L5)*24),IF(O5<N5,((O5+1)-N5)*24,(O5-N5)*24),IF(Q5<P5,((Q5+1)-P5)*24,(Q5-P5)*24))

Example in the file (only the first week has the formula).

I hope that I could help you with this.

[#3]

hey, thanks so much this is exactly what i was trying to do