How about:

=HOUR(A3)&MINUTE(A3)

Hope this helps
Rowan

"Steved" wrote:

Hello from Steved

9:37am to 937
2:20pm to 1420

Please could I have a formula to do the above

Thankyou.