Want to copy time in dot format from one cell to another

aakhan2011

New member
Joined
Jan 16, 2014
Messages
17
Reaction score
0
Points
0
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 !!!

View attachment Sample.xlsx

Regards,
AAK
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,520
Reaction score
5
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Hi there,

Try this formula (in row2):

=SUBSTITUTE(MID(C2,FIND(":",C2,1)+1,FIND(".",C2,1)-FIND(":",C2,1)-1),":",".")

Workbook attached
 

Attachments

  • Sample.xlsx
    9.5 KB · Views: 17
Top