Round up time half an hour

[JBM18]

All,

I could use some help with a formula or vba.



I am looking for something for Access that will work the same as Excel's forumla below:

=TIME(HOUR(A1),CEILING(MINUTE(A1),30),0) --where time field is A1

I want to round up times up half an hour (except the times right on :00 and :30). I do not want to round to the nearest half an hour.

Example of what I am looking for:
Time Formula Changes To
12:10 12:30
12:00 12:00
12:22 12:30
11:55 12:00


Cheers,

[weekend00]

newtime: (int(oldtime*48+0.999999999999) )/48

half hour is 1/48 of one day.

[JBM18]

Perfect.

I used that in combination with a format function to get:

Format(((Int([order_time]*48+0.999999999999))/48),"h:nn AM/PM")

Now my query is exactly what I need. Thank you for the help