Hi

=HOUR(A1)*100+MINUTE(A1)
and format as General

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Steved" wrote in message
...
Hello from Steved

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

Please could I have a formula to do the above

Thankyou.