Reply to thread

Message: [QUOTE="lozzauk13, post: 7417609"] 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 ar 31 per year times by 7.18 (36.5 hour week divided by 5) to give me total of holiday hours. That bits fine. the issue im having is, im recording the dates booked and the shif pattern. for example, A1 - 08:00 ... B1 - 18:00 ive used the forumula c1 =su b1-a1 = 10 hours. then ive done d1 0:30 (break) e1 =sum c1 - d1 = 9:3 which is correct. however if doing a 12 hour shift then the break is 1 hour, and i can use the auto forumla as it only does 30 min break on 12 hours. if trie to see if i can do a if command such as if e1>11:30 - 0:30 = 11:00 th reason ive done it still as - 0:30 is due to auto forumla alread minusing 30 but i get an error. i aint that advanced on excel so i really stumped. hoping someone can advise. cheer [/QUOTE]