VBA Formula for 30 minutes less a time value not working the way I need

[Ark68]

I have this code...

With .cells(rw, 2)
     mm2 = DateAdd("n", -0.5, sh.Cells(rw, 6))
    .Value = "<" & Format(mm2, "h:mmA/P")
End With

The value in sh.Cells(rw,6) = 45075.7916666667 (May 29, 2023 7:00:00 PM)
The result for variable mm2 after the forumal is executed is 2023-05-29 7:00:00 PM

I am looking for mm2 to be 30 minutes less (2023-05-29 6:30:00 PM), but I'm not getting that result.

 

[Ark68]

mm2 = DateAdd("n", -30, sh.Cells(rw, 6))

 

[Peter_SSs]

Duplicate to: VBA Formula Not Removing 30 Minutes From Time

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread. I have also removed the marked answer from this thread and moved it to post #6 of the linked thread where this exact same answer was provided to you two weeks ago (& not acknowledged by you)