Format Cell

  • Thread starter Thread starter eycf
  • Start date Start date
E

eycf

Can someone let me know why to batch convert a set of column data fro
number format to time format in xx:xx:xx

e.g. 1223 -> 12:23:00

Thank
 
Hi

Using a helper column put in:
=VALUE(LEFT(A2,2)&":"&RIGHT(A2,2))
and format the result as time.
If you are happy with the result, don't forget to Edit / Copy and Edit /
Paste Special Values to fix the figures.
 
Hi
enter the fololowing formula in a separate cell (and format this cell
as time):
=TIME(LEFT(A1,2),RIGHT(A1,2))

Note: works only if you always have 4 digit time values in cell A1
 
It may be bad practice but just out of interest the ubiquitous double
negative also works

=--(LEFT(A2,2)&":"&RIGHT(A2,2))

Rgaards

Sandy
--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


Andy B said:
Hi

Using a helper column put in:
=VALUE(LEFT(A2,2)&":"&RIGHT(A2,2))
and format the result as time.
If you are happy with the result, don't forget to Edit / Copy and Edit /
Paste Special Values to fix the figures.
Click to expand...
 
Back
Top