Transpose Datefield from rows to column + Print time diff

view story

http://www.unix.com – Hi Experts, Can you please help me in transposing Datefield from rows to column and calculate the time difference for each of the Jobids: Input File: Code: 08/23/2012 12:36:09,JOB_5340 08/23/2012 12:36:14,JOB_5340 08/23/2012 12:36:22,JOB_5350 08/23/2012 12:36:26,JOB_5350 Required Output: Code: 08/23/2012 12:36:14,08/23/2012 12:36:09,00:00:05,JOB_5340 08/23/2012 12:36:26,08/23/2012 12:36:22,00:00:04,JOB_5350 Many Thanks (HowTos)