Hi guys i was wondering if anyone can advise the best way to do this.

im working out holiday hours owed to me. so ive done the days which are 31 per year times by 7.18 (36.5 hour week divided by 5) to give me a total of holiday hours. That bits fine.

the issue im having is, im recording the dates booked and the shift pattern.

for example, A1 - 08:00 ... B1 - 18:00 ive used the forumula c1 =sum b1-a1 = 10 hours. then ive done d1 0:30 (break) e1 =sum c1 - d1 = 9:30 which is correct.

however if doing a 12 hour shift then the break is 1 hour, and i cant use the auto forumla as it only does 30 min break on 12 hours. if tried to see if i can do a if command such as if e111:30 - 0:30 = 11:00 the reason ive done it still as - 0:30 is due to auto forumla already minusing 30 but i get an error. i aint that advanced on excel so im really stumped. hoping someone can advise.

cheers