Hello Sir,
In this worksheet, I would like to fill in the data in column G17:L23 from
B17:E23. If anybody could help me to get the formula in G17:L23.
Your help is very much appreciated. Thank you.
We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
Hello Sir,
In this worksheet, I would like to fill in the data in column G17:L23 from
B17:E23. If anybody could help me to get the formula in G17:L23.
Your help is very much appreciated. Thank you.
Hi There
Not really understanding what you are asking here...
The reference range B17:E23 is larger than the output range G17:L23 i.e. the reference range B17:E23 contains a cell count of 28, whilst the output range G17:L23 contains a cell count of 42, so you cannot copy one to the other !!!
Which range/cells exactly do you need from the reference range and where in the output range do you expect to see the result?
Also, what do you expect to see in the output range G17:L23 when derived from the input range?
Why is PH circled and 1-9 respectively?
Thanks
Hello again,
Very sorry for my poor questions. Here I am doing the corrections.
I would like to know what formula is to be used in the columns "PUBLIC HOLIDAY" for calculating hours of day duty and night duty in column K16:L23. Working hours are as follows:
7am to 2pm : morning duty
2pm to 9pm: afternoon duty
9pm to 7 & 8am night duty but night overtime calculates from 10pm to 6am.
Thank you very much.
Don’t have an account yet? Register yourself now and be a part of our community!