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