Calculating the epoch time from standard time using awk and calculating the duration

view full story

http://www.unix.com – Hi All, I have the following time stamp data in 2 columns Code:     Date    TimeStamp(also with milliseconds) 05/23/2012 08:30:11.250 05/23/2012 08:30:15.500 05/23/2012 08:31.15.500 . . etc From this data I need the following output. Code: 0.00( row1-row1 in seconds) 04.25( row2-row1 in seconds) 64.25(row3-row1 in seconds) I tried to convert the second column into seconds using HH*60*60+MM*60+SS+MS(milliseconds) formula and subtracting line by line but the problem is if the date changes at some row, I don't know how to proceed. May be converting ecah colum (HowTos)