Thanks for your rapid response and welcome!
the date and time are in H2: 4/12/2010 5:00:51 AM
Therefore, I typed =CEILING(H2,"00:30:00"+0)
The column should come up as 4/12/2010 5:30:00 AM, but it came up as 30:00.
Hopefully this makes sense! Thanks!