Good day, My Name is Luis and I new here. I find this forum as useful. I just want to ask something, Is there any formula that will fixed the seconds into 00.

Here's my sample format:

7/2/2021 10:01:45 PM and I want to to change it to: 7/2/2021 10:01:00 PM

any tip or formula on how to fixed the seconds value into zero?

Thank you in advance.