Mar 11 2021 06:15 AM
Hi
I have following question:
I have an xls with all dates related to samples brought in the lab. Dates are expressed as such dd/mm/yyy hh:mm
If hh:mm are later than 20:00, I would like to convert these data into next day 04:45
Example 02/10/2020 23:30 has to change into 03/10/2020 04:45. Or 23/02/2021 21:01 will be 24/02/2021 04:45
How can I do this?
Regards
Sara
Mar 11 2021 07:46 AM
Mar 11 2021 07:50 AM