Sponsored Content
Top Forums Shell Programming and Scripting Add data in days:hours:min:sec format Post 302110982 by cfajohnson on Saturday 17th of March 2007 11:39:01 AM
Old 03-17-2007
Quote:
Originally Posted by krishna_sicsr
I want to add these no. these are in the format of
days:hours:minutes:sec
I want result in this format only

0:00:04:59
0:00:00:12
0:00:00:28
0:00:00:03
0:01:29:35
0:00:00:19
0:01:05:21

You have to convert the times to integers first, then convert them back to your format.
Code:
awk -F: '{
 total += $1 * 86400 + $2 * 3600 + $3 * 60 + $4
}
END {
  hours = int((total % 86400) /3600)
  minutes = int((total % 3600) / 60)
  days = int(total / 86400)
  secs = total % 60
  print days ":" hours ":" minutes ":" secs
} '

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Difference in day-hours-minutes-seconds format

Hi experts, I am reading two log files and passing dates as output to a txt file. Code is given below: echo "Start Time:" >> Report.txt cat start.log | while read LINE1 do echo $DATE1 >> Report.txt done echo "End Time:" >> Report.txt cat end.log | while read LINE2 ... (7 Replies)
Discussion started by: Sreejith_VK
7 Replies

2. Shell Programming and Scripting

How to get previous 5 min time stamp in hh:mm format ?

Hi All, How to get previous 5 min time stamp in hh:mm format ? suresh (1 Reply)
Discussion started by: suresh3566
1 Replies

3. UNIX for Dummies Questions & Answers

Capture running process for 2 hours with an interval of 10 sec

Hi, Can any one help me on this. How to capture the running process for two hours with an interval of 10 sec. Thanks in andvance Double post, continued here, thread closed (0 Replies)
Discussion started by: sarathkumar
0 Replies

4. Shell Programming and Scripting

Capture running process or 2 hours with an interval of 10 sec

Hi, Can any one help me on this. How to capture the running process for two hours with an interval of 10 sec. Thanks in andvance (1 Reply)
Discussion started by: sarathkumar
1 Replies

5. Shell Programming and Scripting

Data stream between min and max

Hi, I have a text file containing numbers. There are up to 6 numbers per row and I need to read them, check if they are 0 and if they are not zero check if they are within a given interval (min,max). If they exceed the max or min they should be set to max or min respectively, if they are in the... (4 Replies)
Discussion started by: f_o_555
4 Replies

6. Shell Programming and Scripting

Get the no of hours between days

Hi, i have a date 1- 2013101511 date2 -2013101812 need toget the no of hours between them,can any one tellme the logic. (6 Replies)
Discussion started by: sandeep karna
6 Replies

7. Shell Programming and Scripting

Can anyone help me to print UNIX epoch time to days,hours,min,sec ?

I have unix epoch time 1441678454803, Can you please help me to print this time in below format ? DAY,HOUR,MIN,SEC Appreciate your help!!! Thanks, Prince (7 Replies)
Discussion started by: prince1987
7 Replies

8. Solaris

How to run cron entry every 5 min during office hours only?

Hi I need to setuop a cron entry to run every 5 min, only in office hours (between 8:00AM to 18:00PM, I did the following: 0,5,10,15,20,25,30,35,40,45,50,55 8,9,10,11,12,13,14,15,16,17,18 * * * /home/xxx/zzz.ksh But somehow does not work. Could it be wrong? (8 Replies)
Discussion started by: fretagi
8 Replies

9. Shell Programming and Scripting

Find hours difference between two dates in given format

I have two dates in below format, how would I find the hours difference between the two dates. Im using AIX and ksh. Current date : Wed May 17 14:34:41 SGT 2017 File date : Thu Apr 27 20:52:41 SGT 2017 (3 Replies)
Discussion started by: simpltyansh
3 Replies

10. UNIX for Beginners Questions & Answers

How to convert days hours minutes seconds to minutes?

Hi, please help with below time conversion to minutes. one column values: 2 minutes 16 seconds 420 msec 43 seconds 750 msec 0 days 3 hours 29 minutes 58 seconds 480 msec 11 seconds 150 msec I need output in minutes(total elapsed time in minutes) (2 Replies)
Discussion started by: ramu.badugula
2 Replies
DATEINTERVAL(3) 							 1							   DATEINTERVAL(3)

The DateInterval class

INTRODUCTION
Represents a date interval. A date interval stores either a fixed amount of time (in years, months, days, hours etc) or a relative time string in the format that DateTime's constructor supports. CLASS SYNOPSIS
DateInterval DateInterval Properties o public integer$y o public integer$m o public integer$d o public integer$h o public integer$i o public integer$s o public integer$invert o public mixed$days Methods o public DateInterval::__construct (string $interval_spec) o publicstatic DateInterval DateInterval::createFromDateString (string $time) o public string DateInterval::format (string $format) PROPERTIES
o $y - Number of years. o $m - Number of months. o $d - Number of days. o $h - Number of hours. o $i - Number of minutes. o $s - Number of seconds. o $invert - Is 1 if the interval represents a negative time period and 0 otherwise. See DateInterval::format. o $days - If the DateInterval object was created by DateTime.diff(3), then this is the total number of days between the start and end dates. Otherwise, $days will be FALSE. Before PHP 5.4.20/5.5.4 instead of FALSE you will receive -99999 upon accessing the prop- erty. PHP Documentation Group DATEINTERVAL(3)
All times are GMT -4. The time now is 01:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy