time diff help


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting time diff help
# 1  
Old 10-25-2008
time diff help

Code:
Input file: 

Tue Oct 21 12:56:35 2008 Started
Tue Oct 21 12:56:39 2008 Completed
Tue Oct 21 12:57:25 2008 Started
Tue Oct 21 12:57:32 2008 Completed
Tue Oct 21 12:58:12 2008 Started
Tue Oct 21 12:58:50 2008 Completed

Output required:

Tue Oct 21 12:56:35 2008 Started
Tue Oct 21 12:56:39 2008 Completed
Total=4 secs
Tue Oct 21 12:57:25 2008 Started
Tue Oct 21 12:58:32 2008 Completed
Total=67 secs
Tue Oct 21 12:58:12 2008 Started
Tue Oct 21 12:58:50 2008 Completed
Total=38 secs


I tried something like this:

awk -v secs=$((`date +%s -d"Tue Oct 21 12:56:39 2008"` - `date +%s -d"Tue Oct 21 12:56:35 2008"`)) '{print secs}'

I want to calculate the time diff using gnu date; Please help

# 2  
Old 10-25-2008
Try this script.
Code:
#!/bin/sh
if [ $# -ne 1 ];then
        echo Usage: script file; exit 1;fi
while read line
do
 case ${line##* } in
  Started)      start=$(date +%s -d "${line% *}")
                echo "$line";;
  Completed)    end=$(date +%s -d "${line% *}")
                echo "$line"
                echo "Total=$(($end - $start)) sec";;
 esac
done < $1

# 3  
Old 10-25-2008
Danmero, thanks a lot.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Calculate Time diff in milli milliseconds(Time format : HH:MM:SS,NNN)

Hi All, I have one file which contains time for request and response. I want to calculate time difference in milliseconds for each line. This file can contain 10K lines. Sample file with 4 lines. for first line. Request Time: 15:23:45,255 Response Time: 15:23:45,258 Time diff... (6 Replies)
Discussion started by: Raza Ali
6 Replies

2. Shell Programming and Scripting

Diff between two time in hours in last column

Dear All I want to diff between two time(FIRST 4 COLUMN) in hours in last column. Kindly help me for same. 2013-11-23 15:51:23 2013-11-23 12:20:06 BRC023 CG 2013-11-23 15:51:23 2013-11-23 12:20:08 BRC064CG 2013-11-23 15:51:23 2013-11-22 13:17:49 BLM003 NG 2013-11-23 15:51:23 2013-11-22... (9 Replies)
Discussion started by: jaydeep_sadaria
9 Replies

3. Shell Programming and Scripting

Time Stap Diff using Bash

hi all kindly i want to subtract to time stamps like: t1=08:35:20 t2=08:36:58 diff=00:01:38 <<<< or diff=01:38 <<<< using bash thanks alot (9 Replies)
Discussion started by: teefa
9 Replies

4. Shell Programming and Scripting

Transpose Datefield from rows to column + Print time diff

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: 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:... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

5. Shell Programming and Scripting

How to make diff show differences one line at a time and not group them?

Is there a way to tell diff to show differences one line at a time and not to group them? For example, I have two files: file1: line 1 line 2 line 3 diff line 4 diff line 5 diff line 6 line 7 file2: line 1 line 2 line 3 diff. line 4 diff. line 5 diff. line 6 line 7 (13 Replies)
Discussion started by: mmr11408
13 Replies

6. Shell Programming and Scripting

.procmailrc and uudeview (put attachments from diff senders to diff folders)

Moderator, please, delete this topic (1 Reply)
Discussion started by: optik77
1 Replies

7. Shell Programming and Scripting

Time Diff in shell script

Hi all , i am trying to calculate time difference btw the script execution I am using solaris start_time=`date +%s` sleep 2 end_time=`date +%s` duration=`expr $end_time - $start_time` when i try to subtract i get the error line 13: %s - -time : syntax error: operand expected... (3 Replies)
Discussion started by: posner
3 Replies

8. Shell Programming and Scripting

diff in date/time ?

the o/p is : Start Time: 2008-02-19 00:13:16,338 End Time: 2008-02-19 23:43:17,974 How to find the diff in time..........? (1 Reply)
Discussion started by: ali560045
1 Replies

9. UNIX for Advanced & Expert Users

Diff b/w modification & updated time

Hi All, What is the difference b/w last modification time and last updated time. Thanks Sweta (1 Reply)
Discussion started by: sweta
1 Replies

10. UNIX for Dummies Questions & Answers

Help with date and time diff

Hi , Can somebody please help me with this. The date format is in MM/DD/YY HH24:MI:SS suppose I have a start_date=09/03/02 04:15:02 & Finish date= 09/04/02 07:13:51 I want to find out the difference between the two ie finish_time-start time. How can I do this. Morever I want the... (2 Replies)
Discussion started by: rooh
2 Replies
Login or Register to Ask a Question