Hello I have a spreadsheet with a lot of data, Column A shows the Day/Date for example in Cell A2 Monday/01/06/2020
In Column B I have the time in 24hr format 02:14. Im looking for a formula that will show in Column C if the Date falls on a Weekday (Monday to Friday) between the hours of 08:00 and 17:00 this will show "Within Hours" any thing out with this will be "Out of Hours".
If the day is a Saturday or a Sunday this will also show "out of hours". Is there a formula for this? Thanking you in advance for any help.
Thank
In Column B I have the time in 24hr format 02:14. Im looking for a formula that will show in Column C if the Date falls on a Weekday (Monday to Friday) between the hours of 08:00 and 17:00 this will show "Within Hours" any thing out with this will be "Out of Hours".
If the day is a Saturday or a Sunday this will also show "out of hours". Is there a formula for this? Thanking you in advance for any help.
Thank