Hi I downloaded a file in excel and I have the time come up as follows in rows:-

741

952

1010

843

1244

1244

809I have right clicked and selected format cells to select 13:30 in the time / location US in format cells command and get this instead.

0:00

0:00

0:00

0:00

0:00

0:00

0:00no matter what format I try I get this. Any Ideas?

The data need to be in a Time format, ie 7:41

9:52

10:10other wise Excel just sees numbers.

The colon tells Excel the data is a Time.MIKE

message edited by mmcconaghy

Here is quick formula to convert your numbers to time: Copy your data to column A

In cell B1 enter the formula:

=TIMEVALUE(IF(LEN(A1)=3,LEFT(A1,1)&":"&RIGHT(A1,2),LEFT(A1,2)&":"&RIGHT(A1,2)))

Drag down as many rows as needed.

Then on column B do a Copy / Paste / Values.

See how that works for you.

MIKE

Big thanks all sorted.

Ask Your Question

Weekly Poll

Do you trust big tech companies to not misuse personal data?

Discuss in The Lounge

Poll History