I want to extract only the date from below-mentioned Date & Time format & then use it for computing the duration of certain activity.
08/28/2023 02:45:17 AM PDT
DATEONLY formula is not working with this Date-Time format. This date & time format is extracted from our ERP system reports & can not be changed.
Can someone help me to extract only date & then use it calculate the duration between two dates?
Thanks in advance!