Time Formatting
You can address dlw's 2 concerns by changing that formula from
=LEFT(A1,2)&":"&RIGHT(A1,2)
to
=--(LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2)) and formatting appropriately as
time,
or by using
=TIME(LEFT(A1,LEN(A1)-2),RIGHT(A1,2),)
--
David Biddulph
"dlw" wrote in message
...
in a helper column:
=LEFT(A1,2)&":"&RIGHT(A1,2)
note, this turns it into a text so you can't do math on it anymore, and
times before 10 must be formatted 0904, etc
"Liz J" wrote:
I'm looking at time data that is in army-time, but it does not have the
colons. So, the entire row has figures like this 2204, instead of 22:04.
Could you please help me to format this properly?
Thank you!
|