Forum Discussion
Dates in excel
Hello, when the received date is after 03PM, is there a formula to consider received date to be the next day for example, received date is 12/12/2023 15:05 PM the SLA is counted from the next work...
AlaaElHussieny There are a number of ways to accomplish this. Here's one possibility...
=IF(A2-INT(A2)>15/24, INT(A2)+32/24, A2)
...where A2 is the Received Date (see image below).
Adjusted Date/Time
