Time to number

[Guest]

Hello from Steved

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

Please could I have a formula to do the above

Thankyou.

 

[Arvi Laanemets]

Hi

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

 

[Guest]

How about:

=HOUR(A3)&MINUTE(A3)

Hope this helps
Rowan

 

[Guest]

Thankyou