Sponsored Content
Top Forums UNIX for Beginners Questions & Answers How to calculate time duration in Linux? Post 303035411 by RudiC on Thursday 23rd of May 2019 07:10:56 AM
Old 05-23-2019
With Linux you should have GNU date available. Try


Code:
awk -F\|   '
        {printf "%s", "echo \"" $0 " |"
        }
NR == 1 {print " Duration\""
        }
NR > 1  {print  "$(( $(date +%s -d\"" $4 " " $5 "\") - $(date +%s -d\"" $2 " " $3 "\") )) \""
        }
' file | sh

SID   |   Date     |   Starttime   |Date         |End  time | Duration
 1607 |2019-04-05|13:06:42|2019-04-05|13:07:12 |30 
 2327 |2019-04-05|13:57:26|2019-04-05|13:57:43 |17


Two caveats:
1) with your data structure, the system won't know if you're talking 5th April, or 4th May.
2) Above will calculate difference in seconds only. No further formatting like HH:MM:SS will be done; that'll be up to you (search these fora, for example)
This User Gave Thanks to RudiC For This Post:
 

10 More Discussions You Might Find Interesting

1. Solaris

Finding list of modified files for a particular time duration

Hi , I am trying to find out the List of files modified or added aftter installation of any component on SUN solaris box . But i am not able to do it using ls or find command . Can somebody help me out ? Thanks Sanjay Gupta (2 Replies)
Discussion started by: sanajyg_mnit
2 Replies

2. Shell Programming and Scripting

date duration fail to calculate

Hi Everyone, I was very sad after a long way but still cannot figure out the duration between two date. $date1="20090812 23:48:56"; $date2="20090813 00:01:37"; The output will be "001241". I did the following tries, like print localtime(UnixDate(ParseDate("20090812 23:48:56"),"%s"));... (2 Replies)
Discussion started by: jimmy_y
2 Replies

3. 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

4. Shell Programming and Scripting

How to get time duration between two human readable time stamp in Unix?

Here is two time I have: Jul 12 16:02:01 Jul 13 01:02:01 and how can I do a simple match to get difference between two time which is 09:00:00 Thanks in advance. (3 Replies)
Discussion started by: ford99
3 Replies

5. Shell Programming and Scripting

Convert Date from File and Calculate Duration

Hi - I am looking for a little help to read in 2 date fields from a file in format: 20120508134012.3 yyyymmddhhmmss.tenths of a second So i want to: 1. Read in the 1st date from the file 2. Read in the second date from the file 3. Calculate the difference in minutes (or seconds) 4. ... (5 Replies)
Discussion started by: Newbie2012
5 Replies

6. Shell Programming and Scripting

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

Hi All, I have the following time stamp data in 2 columns 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. 0.00( row1-row1 in seconds) 04.25( row2-row1 in... (5 Replies)
Discussion started by: ks_reddy
5 Replies

7. Shell Programming and Scripting

Getting the Start, End time and duration using date command

Oracle Enterprise Linux We want to track how long a process takes to complete its execution. This is what we want in the schell script Before the process is started , get the time with date, hours and minutes execute the process After the process has ended , get the time with date,... (5 Replies)
Discussion started by: omega3
5 Replies

8. Shell Programming and Scripting

Perl ::duration of time in between dates

Hello All, I have two strings with date and time as follows.. $starttime= "06/11/2013 "; $starttime= "05:15"; $enddate="06/12/2013"; $endtime="04:45"; dates are in mm/dd/yyyy format and time in military format. and I am looking the duration of time(in minutes) in between dates. ... (3 Replies)
Discussion started by: scriptscript
3 Replies

9. UNIX for Dummies Questions & Answers

Script shell calculate mean arrival request duration

hello, I have implemented this command : tshark -eth0 -T fiels -e frame.time et sip.Request-Line -z sip,stat > test2.txt the result of this command : test.txt: Aug 27, 2013 23:06:47.334270000 INVITE Aug 27, 2013 23:06:47.335045000 SIP/2.0 401 Unauthorized Aug 27, 2013... (1 Reply)
Discussion started by: Amouna
1 Replies

10. UNIX for Dummies Questions & Answers

How to list files for particular duration of time .?

Hi there is a lot of file dated from last week till ofpresent date. if i want to list only last 3 days files using ls command how can i do it please suggest. below is the list of the file. and i want to list files from MAy 12 to May 16. Nov 22 2011 NSSM.UPPLSCPLB81 Jan 12... (2 Replies)
Discussion started by: scriptor
2 Replies
qwavfade(1)							 quelcom man pages						       qwavfade(1)

NAME
qwavfade - fade in/out wav files SYNOPSIS
qwavfade [option]... file... DESCRIPTION
qwavfade modifies a wav file applying on it a fade in or a fade out or both. a fade consists in modifying progressively the level of the wav as if you were slowly increasing or decreasing the volume. a fade in con- sists in increasing the volume starting from a low level at the beginning of the wav. a fade out consists in decreasing the volume to a low level at the end of the wav. OPTIONS
-d <duration>[<format>], --duration=<duration>[<format>] duration is a positive integer that specifies the duration of the fade. the value is treated as a sample number unless a format specifier is used. see the FORMATS section below for information. the default value is five seconds. this option overrides the --length option explained below. -h, --help show a brief help and exit. -i, --in just fade in. don't fade out. by default, fade in and fade out. -l <time point>, --length=<time point> time point specifies the length(=duration) of the fade. see the TIME POINTS section below for information. this option is quite sim- ilar to the --duration option above. its easier to use though not as powerful than the previous one. the default value is five sec- onds. this option overrides the --duration option explained above. -o, --out just fade out. don't fade in. by default, fade in and fade out. -t, --test this option can be used to create and fade a tests files instead of modifying to original file. a test file will be created for each type of selected fade (in or out). the name of the test file will be fadein.<file> or fadeout.<file. the duration of the test files is the fade duration plus two seconds. -v, --verbose show more detailed info. -V, --version show version and exit. TIME POINTS
the time points is a easier way to specify the length (or duration) of a fade with a millisecond resolution. here's its formal form: [h:[m:]]s[.ms] where h value is a positive integer meaning hours. m value is a positive integer meaning minutes. s value is a positive integer meaning seconds. ms value is a positive integer meaning milliseconds. only the seconds specifier is required. here are a couple of examples: 1:23:45.67 2:0.001 FORMATS
the --duration option can have also an optional modifier. if this modifier is not used, then the value provided with the corresponding cut option will be interpreted as a number of samples. since most of the times will be difficult to specify a duration in terms of samples, the following modifiers are provided: j value is interpreted as milliseconds. m value is interpreted as minutes. s value is interpreted as seconds. b value is interpreted as bytes. k value is interpreted as kbytes (1024 bytes). M value is interpreted as megabytes (1024 kbytes). in either case, the values specified will be rounded to get an integer number of samples. EXAMPLE
suppose you want to fade in and out the fantastic song live.in.concert.wav using a fade duration of 5 seconds: first we are going to test: qwavfade -t -d 7s live.in.concert.wav hear the test fades: my-favourite-wav-player fadein.live.in.concert.wav my-favourite-wav-player fadeout.live.in.concert.wav if you want to try with another duration, jump to the first step and change the duration argument. and if you're happy with the tests: qwavfade -d 5s live.in.concert.wav NOTES
qwavfade doesn't allow both types of fades (in and out) to overlap. if you want to fade in and out a wav file, and the two regions to fade overlap, then probably you made a mistake. in any case, you can do it fading separately. BUGS
tests has been done only with 44100 Hz 16 bit stereo files, though it may work with mono/stereo 8/16 bits files. AUTHOR
dmanye@etse.urv.es http://www.etse.urv.es/~dmanye/quelcom/quelcom.html SEE ALSO
qwavinfo(1), qwavjoin(1), qwavcut(1), qwavsilence(1), qwavheaderdump(1) qmp3info(1), qmp3join(1), qmp3cut(1), qmp3check(1), qmp3report(1) quelcom 0.4.0 february 2001 qwavfade(1)
All times are GMT -4. The time now is 07:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy