Sample of original data as follow;

Purpose : To find time difference between process 1 & 2
The solution;

i. Convert date and time format to text, use TEXT function

if the date format not converted to text, date will be define as number
such as 40,118 for 1st Nov 2009 instead of 1/11/09
Second


such as 40,118 for 1st Nov 2009 instead of 1/11/09
i. Combine both date & time text using CONCATENATE function,
tips : follow standard date & time format setting i.e dd/mm/yr_hh:mm am/pm
