Converting HH:MM into 4figs

[Median]

This should be so simple, but for some reason I can't work out a way to do it.

Everything I've tried so far, just doesn't seem to work (i.e. left, right, concatenate)

I'm looking to turn:

14:00
17:05
18:15

into..

1400
1705
1815

Basically into 4fig numbers. Should be so easy!!!

Any help would be much appreciated (drivin' me nutty this!)

Ty

Median

[shg]

If those are actual time values, just format as hhmm

Or maybe this is what you're trying to do:

	A	B	C
2	14:00	1400	B2: =--TEXT(A2, "hhmm")
3	17:05	1705
4	18:15	1815

[Median]

If those are actual time values, format at hhmm
Or maybe this is what you're trying to do:
[/table][/size]

Omg. I knew it was easy

Ty Shg