The cells are probably formatted as text at the time data was entered. You
should be able to use the TIME function. Assuming the time is always in
hh:mm format, to convert the text value in A1, you use:

=TIME(LEFT(A1,2),RIGHT(A1,2),0)


"Polochilde" wrote:

Hello,

I import data in Excel from a software that keeps people punch in-out times.
The data appears as times (eg 21:30 or 20:00...) however I cannot change that
into a numeric value. Using format option did not help and when try to use a
formula the result is an error, "value".

Could you please suggest how to import as numbers or change data to numbers?
--
Many Thanks. Warmest Regards,