Hello,
I am trying to make a formula that looks at a date and works out if it came in at a certain time to get a due date.
IF the item comes in on 1 day between 08:00 and 18:00 the job has 8 days to complete.
IF the item comes in between 18:00 the day before and 08:00 on that day they have 8 days up to 18:00 from that day to complete.
I cant work out how to get the formula to work out the day before and add 8 days from the next day.
05/04/2021 09:56:00 This one would have 8 days to complete up to 18:00 on the 13/04/21
25/03/2021 02:00:00 this one would have 8 days to complete up to 18:00 on the 21/04/21
25/03/2021 19:21:00 This one would have 8 days to complete up to 18:00 on the 22/04/21
Thanks for the help.
Bookmarks