=HOUR(A1)
=MINUTE(A1)
--
David Biddulph

"ConnieB" wrote in message
...
I have time stored in Military time format. 17:30. When I try to split
the
field in to one for hr and one for min. The time will split as 5 instead
of
17 then 30 and then Pm in the last cell. How do I keep the 17?
Thanks
Connie