=TEXT(IF(AND(MINUTE(F2)>=15,MINUTE(F2)<45),HOUR(F2)&":30", IF(MINUTE(F2)>=45,HOUR(F2)+1&":00", HOUR(F2)&":00")), "H:MM AM/PM")
=TEXT(IF(AND(MINUTE(F2)>=15,MINUTE(F2)<45),HOUR(F2)&":30",
IF(MINUTE(F2)>=45,HOUR(F2)+1&":00",
HOUR(F2)&":00")),
"H:MM AM/PM")