Dates in excel

Copper Contributor

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 working day which should start 12/13/2023 08:00 AM

 

AlaaElHussieny_2-1703739568099.png

 

 

1 Reply

@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/TimeAdjusted Date/Time