Converting military times to numbers 1

[Wire216]

I have a column that contains times in military format. I want to convert the times to numbers, with no formatting.

For example:

Right now the columns show the following:

0:01
0:23
2:14
13:32
19:54

Their actual values are:

12:01:00 AM
12:23:00 AM
2:14:00 AM
1:32:00 PM
7:54:00 PM

I want it to instead have the following values:

1
23
214
1332
1954

They should be formatted as numbers, with no indication that they represent times.

Is this possible?

I have a worksheet that contains military times in number format that I need to compare against.

Thanks.

 

[TonyJollans]

This should do it ....

[blue][tt] =VALUE(TEXT(A1,"hhmm"))[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[Wire216]

Works great, thanks.