Excel query...

ChowClown

Senior member
2,732 56
Hi,

I have the following data format in one column:

19/07/04 13:21

I need the time data in a separate column.

Any ideas?

Cheers.
 

FTSE Beater

Experienced member
1,518 4
Hi ChowClown

There is 2 ways of doing it that I know of, (which way you choose will depend on how often you need to do it).

Either write a Excel Macro, or (my preferred way) Using the Text to columns function in the Data menu.

  • Highlight the cells you want, then goto Data->Text to columns.
  • The wizard will appear.
  • Click Delimited, then click next.
  • Under delimiters make sure just Space is ticked.
  • Then click Next.
  • That will bring up the preview of what will happen and click finish if your happy with it :cool:

HTH :)
 

TWI

Senior member
2,527 252
Can you not just just reference the cell in the next column and then format the first to show only date DD/MM/YY and the next to show only HH:MM
 

TheBramble

Legendary member
8,395 1,170
twalker said:
Can you not just just reference the cell in the next column and then format the first to show only date DD/MM/YY and the next to show only HH:MM
I dunno...you kids, always wanting the easy way out!
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock