Change time

[Guest]

I understand that Excel always assumes the first unit of the time value is
hour. Example: If I enter 3:21, it means 3 hours and 21 minutes.

My problem is that I have lot of time data downloaded from another program
into Excel. The time is not displaced as I wish. Example: The information
3:21 should be 3 minutes and 21 seconds. Since the leading value of the hour
as 0 was not included, Excel assumes it's 3 hours and 21 minutes.

Can you think of any way that I can quickly change the data from hh:mm to
mm:ss?

Thanks in advance.

Anne

 

[Guest]

hi Anne

divide by 60

ié if you have 3:21 in a2 use an auxiliar column =a2/60
format as 00:00:00

hth
regards from Brazil
Marcelo

"Anne" escreveu:

 

[Guest]

Hi

Divide it by 60. If you have a whole load, type 60 in a blank unused cell,
select the range to change and select Edit/Paste Special/Divide.

Job done! (Make a backup before you start, though!)

Andy.

 

[Guest]

Thanks Marcelo and Andy.

It's easy. Thanks for your advice.

Anne

 

[Bob Phillips]

In a free cell, enter 60 and copy it to the clipboard

Select all the time cells
Goto Edit>PasteSpecial
Click the Divide button
OK

Reformat the cells to time

Clear the cell with 60 in

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)