Hi All,
I want to copy time which is present as text format to dot format to another cell.
Time in C column is needed to be converted to time in F column by putting some formula to c column data . Please find the attached sheet for the same.
I have a huge amount of data and want the time to convert to a dot format. Please help me as i am a newbie to format conversion in excel.
Thanks in advance !!!
Sample.xlsx
Regards,
AAK
Have you tried using the format painter?
Cheers!
Deep Dave
In F2 Cell
=IFERROR(SUBSTITUTE(MID(C2,FIND(":",C2)+1,FIND(".",C2)-FIND(":",C2)-1),":","."),"")
Drag it down....
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Yes, you are absolutely correct. I works like heaven. Can you please explain me the formula ?
Multiply the result of the formula given by Sixthsense by 1 to convert the result from a text value to a real number that you can work with easily. Do this by adding *1 to the end of the formula and copy down.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks