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

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.

"Anne" wrote in message
...
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

Thanks Marcelo and Andy.

It's easy. Thanks for your advice.

Anne

"Andy" wrote:

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.

"Anne" wrote in message
...
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

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:

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

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

Select all the time cells
Goto EditPasteSpecial
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)

"Anne" wrote in message
...
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