24 hour conversion?

  • Thread starter Thread starter Jim Melton
  • Start date Start date
J

Jim Melton

24 hour conversion?

I have a column with numbers in them that I need to convert to a 24 hour
time format so excel will work with them.

I tried to make a macro but it always returned it the same cell I started
in.

How do I get a macro to add the ":" to all the cells in the column?

or is there a better way to convert a number like 1600 to 16:00?

Thank You
 
You could use the concatenate function ie:

=concatenate(left(cell_ref,2),":",right(cell_ref,2))

Where cell_ref is the cell with the time in it.

HTH
 
Thank You

Edgar said:
You could use the concatenate function ie:

=concatenate(left(cell_ref,2),":",right(cell_ref,2))

Where cell_ref is the cell with the time in it.

HTH
Click to expand...
 
Back
Top