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