Hi Friends 
I have a long file having fields in the form :
Field1 yy/mm/dd hh:mm:ss Duration(Sec)
line 1) 123123 05/11/30 12:12:56 145
line 2) 145235 05/11/30 12:15:15 30
line 3) 145264 05/11/30 13:14:56 178
.
.
I want to subtract yy/dd/dd hh:mm:ss in line (2) from yy/mm/dd hh:mm:ss in line (1) and compare the result(in seconds) with the duration(sec) of line(1).
and echo a message whether it is < or >. I want to apply this to the long file This can be done easily in excel as we usually drag a formula in excel. But in unix how I don't know.
Please Dont refer me to Datecalc as I want specific script to do so.
Thanks In advance.
We have some rules here. One of the them is:
(4) Do not 'bump up' questions if they are not answered promptly. No duplicate or cross-posting and do not report a post where your goal is to get an answer more quickly.
Don't break it again. Another issue is that you keep posting in the forum "Post Here to Contact Site Administrators and Moderators". That forum is not for technical questions, it's for issues with the site itself. Post your questions in an appropriate forum.
And by the way, putting conditions in like "Please Dont refer me to Datecalc as I want specific script to do so." is a good way to limit responses. When you're that selective you really need to hire an expert who will meet all of your demands.