I have a column of time that is showing the minutes as hours and th
seconds as minutes. Example=> 6:49:00 AM needs to be converted t
00:06:49 AM. I need to shift everything to the right one semicolon.
am formated as [hh]:mm:ss. This column does not have a set amount o
rows therefore the fix needs to effect the entire column and should no
be cell specific....By the way this site is a huge Help....I want t
give a big thanks ahead of time

--
Message posted from http://www.ExcelForum.com

Hi caseyoconnor10!

Create a backup in case you want the original data.

Use:
Put 60 in an empty cell
Select that cell and Copy
Select the data to be changed
Edit > Copy > Paste Special > Divide > OK


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(E-Mail Removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"caseyoconnor10 >" <<(E-Mail Removed)>
wrote in message news:(E-Mail Removed)...
>I have a column of time that is showing the minutes as hours and the
> seconds as minutes. Example=> 6:49:00 AM needs to be converted to
> 00:06:49 AM. I need to shift everything to the right one semicolon.
> I
> am formated as [hh]:mm:ss. This column does not have a set amount of
> rows therefore the fix needs to effect the entire column and should
> not
> be cell specific....By the way this site is a huge Help....I want to
> give a big thanks ahead of time.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>