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

  • Thread starter Thread starter caseyoconnor10
  • Start date Start date
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
 
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 address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert HH:MM AM to HH:00 AM 1
convert 00:06 minutes to 6 2
Excel Convert Datetime Stamp to HH and MM Worked 7
time calculation, 24:00 - 16:00 = 8 4
Determine if night shift by start & end time 2
Convert 00:00:00 to a plain number 3
How to convert date from "Fri Aug 22 13:49:20 EDT 2003" 7
Text "12:00 AM" to Time Format 6

Back
Top