=mod(A1,0.5)
--
David Biddulph

"Billy B" wrote in message
...
I am updating an excel worksheet from a query in Access. One of the fields
in
the database is time and the query works. The excel field is formatted as
time and displays 2:00 PM or 14:00 depending on the format. What I need to
do
is have the cell display 2:00. Is that possible? and if so, how?

Thank You