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

C

caseyoconnor10

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
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top