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
Hi there,
Try this formula (in row2):
=SUBSTITUTE(MID(C2,FIND(":",C2,1)+1,FIND(".",C2,1)-FIND(":",C2,1)-1),":",".")
Workbook attached
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Bookmarks