I need help with several of the formulas in this document.
The first one is the time on sheet 1. Pilots have to input their start and finish times along with all the other data. In column M it should calculate the total time on duty. The formula I have works fine but only if they don't work into the following day. However as you can see in row 91 it returns an incorrect result. What is the formula to incorporate working into the next day?
The pilots will be using sheet 1 on a daily basis to input their details. On sheet 2 I want it to autofill based on the date that they put into cell O4. The idea is that they have to report their duty information for the last 28 days. I want the pilots to be able to put the date of the report in cell O4 which will then look at sheet 1 and then populate the fields in sheet 2 to show the information for the last 28 days. The date that gets entered into O4 will be the last date of the report on sheet 2 so cell A49 will match with O4.
I only have very limited knowledge with formulas and whilst I like to have a go I have spent days on this so any help would be greatly appreciated
Bookmarks