Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Calculate time difference between two lines
Top Forums Shell Programming and Scripting Calculate time difference between two lines Post 303009492 by RavinderSingh13 on Friday 15th of December 2017 02:57:02 AM
Old 12-15-2017
Quote:
Originally Posted by vivekn
thanks, I need output in following format
03:46:40
Hello vivekn,

Could you please try following and let me know if this helps.
Code:
awk -F":" 'FNR==1{split($0,a,":");sec1=a[1]*3600+a[2]*60+a[3]} FNR==2{split($0,b,":");sec2=b[1]*3600+b[2]*60+b[3];val=sec2-sec1;ho=int(val/3600);val=val%3600;mi=sprintf("%02d",(val/60));val=val%60;;print ho":"mi":"val}'  Input_file

Output will be as follows.
Code:
3:46:40

EDIT: Adding a non-one liner form of solution too now.
Code:
awk -F":" '
FNR==1{
  split($0,a,":");
  sec1=a[1]*3600+a[2]*60+a[3]
}
FNR==2{
  split($0,b,":");
  sec2=b[1]*3600+b[2]*60+b[3];
  val=sec2-sec1;
  ho=int(val/3600);
  val=val%3600;
  mi=sprintf("%02d",(val/60));
  val=val%60;
  print ho":"mi":"val
}
'   Input_file

Thanks,
R. Singh
Last edited by RavinderSingh13; 12-15-2017 at 04:00 AM.. Reason: Adding a non-one liner form of solution successfully too now.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to calculate this time difference

Hi, Please help me in calculating the time difference between below mentioned timestamps. a=07/17/2007 02:20:00 AM MST b=07/17/2007 02:07:46 AM MST Thanks (2 Replies)
Discussion started by: Prat007
2 Replies

2. Shell Programming and Scripting

How to calculate the time difference...

Hi All, I've written a script which reads all the systems backup information and saves it in a log file. ssh -l ora${sid} ${primaryhost} "tail -2 /oracle/$ORACLE_SID/sapbackup/back$ORACLE_SID.log" |head -1 | awk '{print echo "PREVIOUS:-- Start Date&Time: " $3,$4,echo "|| End Date&Time:... (1 Reply)
Discussion started by: suri.tyson
1 Replies

3. Shell Programming and Scripting

How to calculate the time difference.

Hi All, I've written a script which reads all the systems backup information and saves it in a log file. ssh -l ora${sid} ${primaryhost} "tail -1 /oracle/$ORACLE_SID/sapbackup/back$ORACLE_SID.log" | awk '{print $3,$4,$5,$6}' >> ${RESULTFILE} The output comes as below: 2008-09-30 06.00.01... (2 Replies)
Discussion started by: suri.tyson
2 Replies

4. Shell Programming and Scripting

Formatting output so I can calculate time difference between two stamps

I know there have been a million questions regarding calculating time stamps, and with enough googling, I think I'm almost there (I'm going to use the changing the times into seconds and subtracting solution). My problem is that I'm not sure how to format my log file to get the info I need. Below... (0 Replies)
Discussion started by: DeCoTwc
0 Replies

5. Shell Programming and Scripting

How to calculate time difference between start and end time of a process!

Hello All, I have a problem calculating the time difference between start and end timings...! the timings are given by 24hr format.. Start Date : 08/05/10 12:55 End Date : 08/09/10 06:50 above values are in mm/dd/yy hh:mm format. Now the thing is, 7th(08/07/10) and... (16 Replies)
Discussion started by: smarty86
16 Replies

6. Shell Programming and Scripting

Calculate the Time stamp difference

hi, I have a log file which gives time stamps hh:mm:ss.sssss format in which hh- hours , mm -minutes ss.sssss - seconds.microseconds I need to calculate the time diff between sent time stamp and received time stamp .... could any one please help me.. i am tryin to write a script but... (2 Replies)
Discussion started by: firestar
2 Replies

7. Shell Programming and Scripting

Calculate age of a file | calculate time difference

Hello, I'm trying to create a shell script (#!/bin/sh) which should tell me the age of a file in minutes... I have a process, which delivers me all 15 minutes a new file and I want to have a monitoring script, which sends me an email, if the present file is older than 20 minutes. To do... (10 Replies)
Discussion started by: worm
10 Replies

8. Shell Programming and Scripting

Calculate time stamp difference

Hi All, I am new to shell scripting.I have to write a shell script for the problem statement: "A file is updated continously. If it is not updated for a day then an error message needs to pop up." So the script needs to read the last modified time of that file and current system time .If... (4 Replies)
Discussion started by: bharath.phatak
4 Replies

9. Shell Programming and Scripting

Calculate time difference between pst and pdt dates in perl

Hi, how to calculate the time difference between PST date and PDT date in perl scripting. date1: Mon Dec 31 16:00:01 PST 2015 date2: Tue Mar 19 06:09:30 PDT 2013 and also difference between PST-PST and PDT-PDT need difference in months or days (months prefereble). (3 Replies)
Discussion started by: praveen265
3 Replies

10. Shell Programming and Scripting

Calculate time difference

I have time in a file in HH:MM:SS format as it contents(its not the file creation time). i need this to be converted to epoch time or time since 1970. The time is written into that file by a script, which i cannot modify. Im using AIX machine $ cat abc.txt 10:29:34 (2 Replies)
Discussion started by: gpk_newbie
2 Replies

LEARN ABOUT CENTOS

tk::x11font

X11Font(3)						User Contributed Perl Documentation						X11Font(3)

NAME

       Tk::Font - a class for finding X Fonts

SYNOPSIS

	use Tk::X11Font;

	$font = $widget->X11Font(foundry => 'adobe',
			      family  => 'times',
			      point   => 120
			     );

	$font = $widget->X11Font('*-courier-medium-r-normal-*-*');

DESCRIPTION

	  This module can be use to interrogate the X server what fonts are
	  avaliable.

METHODS

   Foundry( [ $val ] )
   Family( [ $val ] )
   Weight( [ $val ] )
   Slant( [ $val ] )
   Swidth( [ $val ] )
   Adstyle( [ $val ] )
   Pixel( [ $val ] )
   Point( [ $val ] )
   Xres( [ $val ] )
   Yres( [ $val ] )
   Space( [ $val ] )
   Avgwidth( [ $val ] )
   Registry( [ $val ] )
   Encoding( [ $val ] )
       Set the given field in the font name to $val if given and return the current or previous value

   Name( [ $max ] )
       In a list context it returns a list of all font names that match the fields given. It will return a maximum of $max names, or 128 if $max
       is not given.

       In a scalar contex it returns the first matching name or undef

   Clone( [ key => value, [ ...]] )
       Create a duplicate of the curent font object and modify the given fields

AUTHOR

       Graham Barr <Graham.Barr@tiuk.ti.com>

HISTORY

       11-Jan-96 Initial version

       08-Nov-98 Renamed for Tk800.012

COPYRIGHT

       Copyright (c) 1995-1996 Graham Barr. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

perl v5.16.3							    2014-06-10								X11Font(3)
All times are GMT -4. The time now is 04:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy