Hi, i am not new to excel can get by with very basic stuff but i am now trying to do something which is way out of knowledge of excel.
i have 2 sheets, sheet 1 consist's of work rota and paid time it is made up of 4 column's and looks like this below column1 is 701 col2 is sign on plus time col3 is sign off plus time col4 is paid time
701 Sign On : 0350 Sign Off : 1110 Meal Break : 0714 - 0810 Paid Time : 06.24
sheet 2 is where i want to track my week i would like to just input in column 1 the duty number ie 701 and when this is entered for each day of the week the relevant info is dragged from sheet into sheet 2 where a few basic calculations are done that adds the paid time for the week.
my week consists of 7 days monday to sunday
hope this makes sense and someone can assist me
thanks
i have 2 sheets, sheet 1 consist's of work rota and paid time it is made up of 4 column's and looks like this below column1 is 701 col2 is sign on plus time col3 is sign off plus time col4 is paid time
701 Sign On : 0350 Sign Off : 1110 Meal Break : 0714 - 0810 Paid Time : 06.24
sheet 2 is where i want to track my week i would like to just input in column 1 the duty number ie 701 and when this is entered for each day of the week the relevant info is dragged from sheet into sheet 2 where a few basic calculations are done that adds the paid time for the week.
my week consists of 7 days monday to sunday
hope this makes sense and someone can assist me
thanks