LaurenHancy
Board Regular
- Joined
- Aug 5, 2010
- Messages
- 179
Hello you marvelous lot
I have a question regarding calculating business days/hours between 2 dates/times:
Column A = dd/mm/yyyy hh:mm:ss
Column B = Today()
Business hours are 09:00 - 17:00, please may you advise a formula which will count any times after 17:00 to be counted as the next business day.
For Example -1. 01/02/2021 16:50:00 = Need to work out number of NETWORKDAYS with todays date 01/03/2021
2. 01/02/2021 17:02:00 =This will be classed as the next working day as time over 17:00. Work out number of NETWORKDAYS with todays date
Thank you so much for your help.
I have a question regarding calculating business days/hours between 2 dates/times:
Column A = dd/mm/yyyy hh:mm:ss
Column B = Today()
Business hours are 09:00 - 17:00, please may you advise a formula which will count any times after 17:00 to be counted as the next business day.
For Example -1. 01/02/2021 16:50:00 = Need to work out number of NETWORKDAYS with todays date 01/03/2021
2. 01/02/2021 17:02:00 =This will be classed as the next working day as time over 17:00. Work out number of NETWORKDAYS with todays date
Thank you so much for your help.