6:49:00 AM converted to 00:06:49 AM

6:49:00 AM converted to 00:06:49 AM

Post by caseyoconn » Sun, 04 Apr 2004 08:04:45

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

6:49:00 AM converted to 00:06:49 AM

Post by Norman Har » Sun, 04 Apr 2004 08:26:27

Hi caseyoconnor10!

Create a backup in case you want the original data.

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

Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"caseyoconnor10 >" << XXXX@XXXXX.COM >