ExcelBanter - Time to number

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Time to number (https://www.excelbanter.com/excel-worksheet-functions/23757-time-number.html)

Steved

Time to number

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

--
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.

Rowan

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.

Steved

Thankyou

"Steved" wrote:

Hello from Steved

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

Please could I have a formula to do the above

Thankyou.

All times are GMT +1. The time now is 09:29 PM.