Add a new filed in csv based on a value in colum and cal the time diff

Take at look at this post for calculating the difference. You can set the status based on whether you get a _dateparsefailure on the endtime.