How to calculate specific hours between 2 dates Post: 302218503

Sponsored Content

Top Forums Shell Programming and Scripting How to calculate specific hours between 2 dates Post 302218503 by sickboy on Friday 25th of July 2008 10:35:32 AM

07-25-2008

Registered User

Good one, but actually I don't want to take it so far. The only thing I will do is to subtract the weekends. I found a really interesting article how to find how many weekends are between two dates. http://dirtsimple.org/2004/10/nineteen-hundred-weekends.html

So what I thought so far is:
I have the startdate and the closing date.
I wrote this to adjust the startdate to working hours

Code:

    if (startdate.day_of_week in (5,6)) or (startdate.day_of_week == 4 and startdate.hour > 18):
        print 'I am in the first if'
        while True:
            startdate = startdate + mx.DateTime.RelativeDateTime(days=+1)
            print startdate.day_of_week
            if startdate.day_of_week == 0:
                startdate = startdate + mx.DateTime.RelativeDateTime(hour=9,minute=0,second=0)
                break
    elif startdate.day_of_week in (0,1,2,3,4) and startdate.hour < 9:
        startdate = startdate + mx.DateTime.RelativeDateTime(hour=9,minute=0,second=0)
    elif startdate.day_of_week in (0,1,2,3) and startdate.hour > 18:
        startdate = startdate + mx.DateTime.RelativeDateTime(days=+1,hour=9,minute=0,second=0)

but this is only if the startdate is out of the working hours.
It becomes harder when the starting date is for example 17:00. Then I have to keep this 1hour in a temp value calculate for the closing date and add it at the end.

Edit:
If the startdate is within the working times I guess I just have to subtract 15 hours

Last edited by sickboy; 07-25-2008 at 11:50 AM..

sickboy

View Public Profile for sickboy

Find all posts by sickboy

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Calculate days between yyyyMmmdd dates on Solaris

I extract dates from the log file and need to calculate days between two dates. My dates are in yyyyMmmdd format. Example: $d1=2011 Oct 21 $d2=2012 Feb 20 I need to calculate the number of days between $d2 and $d1. This is on Solaris. Any ideas? Thanks, djanu

2. Web Development

Calculate the number of days between 2 dates - PHP

Is this code good for this purpose? <?php $date1 = mktime(0,0,0,01,01,1991); $date2 = mktime(0,0,0,03,22,2012); $diff = $date2 - $date1; $days = $diff / (60*60*24); echo ($days . "<br />"); ?>

3. Shell Programming and Scripting

Calculate the number of days between 2 dates - bash script

I wrote the day calculator also in bash. I would like to now, that is it good so? #!/bin/bash datum1=`date -d "1991/1/1" "+%s"` datum2=`date "+%s"` diff=$(($datum2-$datum1)) days=$(($diff/(60*60*24))) echo $days Thanks in advance for your help!

4. Shell Programming and Scripting

How to Calculate the difference between two dates?

I want the difference between two following date using scripts in terms of no.of days. How I can accomplish this. lastdate=Tue Nov 13 10:30:56 2012 currdate=Wed Dec 15 15:58:21 PAKST 2012 Ouput should be like this: Your Password will expire after = 32 Days on Wed Dec 15 15:58:21 PAKST...

5. Shell Programming and Scripting

Shell script to calculate difference between 2 dates

shell script to calculate difference between 2 dates

6. 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).

7. Shell Programming and Scripting

Collect files for specific hours

I have to fetch files from a location hour wise. Eg files available at location /tmp/data/ are A20140205.1300-1315...... . . A20140205.1400-1415...... . . A20140205.1700-1715...... . . . . Below is the code I have prepared. But it works only for one hour. For instance...

8. UNIX for Advanced & Expert Users

How to get ALL update dates and hours of a file?

Hello, I have a question please, How could I get ALL update dates and hours of a file ? For example: I modified a file on 09/04/2014 at 7:am for the first time. Then, I modified again the same file on 09/04/2014 at 9 am and finally, I modified the same file again on 10/04/2014 at...

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

10. Red Hat

Delete files older than 1week(dates need to be calculate based on file name)

Objective: We have multiple files in a folder and we want to delete all files except for last 1 week files. Note: We are copying these files from original location to this temporary location. So time shown for these files are time when we copied to this location. Not that when file was created....

LEARN ABOUT DEBIAN

grid-cert-info

GRID-CERT-INFO(1)						  Globus Commands						 GRID-CERT-INFO(1)

NAME

       grid-cert-info - Display information about a certificate

SYNOPSIS

       grid-cert-info [-help] [-usage] [-version] [-versions]

       grid-cert-info [-file CERTIFICATE-FILE] [-rfc2253] [-all]
		      [-subject] | [-s]
		      [-issuer] | [-i]
		      [-issuerhash] | [-ih]
		      [-startdate] | [-sd]
		      [-endate] | [-ed]

DESCRIPTION

       The grid-cert-info program displays information contained within a certificate file. By default it shows a text representation of the
       entire certificate. Specific facts about the certificate can be shown instead by using command-line options. If any of those options are
       used, then the default display is suppressed. This can be added to the output by using the -all command-line option.

       If multiple display options are included on the command-line, the facts related to those will be displayed on separate lines in the order
       that they occur. If an option is specified multiple time, that fact will be displayed multiple times.

       The full set of command-line options to grid-cert-info are:

       -help, -usage
	   Display the command-line options to grid-cert-info and exit.

       -version, -versions
	   Display the version number of the grid-cert-info command. The second form includes more details.

       -file CERTIFICATE-FILE
	   Display information about the first certificate contained in the file named by CERTIFICATE-FILE instead of the default user
	   certificate.

       -rfc2253
	   Display X.509 distinguished names using the string representation defined in RFC 2253 instead of the default OpenSSL oneline format.

       -all
	   Display the text representation of the entire certificate in addition to any other facts requested by command-line options. This is the
	   default if no fact-specific command-line options are used.

       -subject, -s
	   Display the subject name of the X.509 certificate.

       -issuer, -i
	   Display the issuer name of the X.509 certificate.

       -issuerhash, -ih
	   Display the default hash of the issuer name of the X.509 certificate. This can be used to locate which CA certificate in the trusted
	   certificate directory issued the certifcate being inspected.

       -startdate, -sd
	   Display a string representation of the date and time when the certificate is valid from. This is displayed in the format used by the
	   OpenSSL x509 command.

       -enddate, -dd
	   Display a string representation of the date and time when the certificate is valid until. This is displayed in the format used by the
	   OpenSSL x509 command.

EXAMPLES

       Display the validity times for the default certificate

	   % grid-cert-info -sd -ed
	   Aug 31 12:33:47 2009 GMT
	   Aug 31 12:33:47 2010 GMT

       Display the same information about a different certificate specified on the command-line

	   % grid-cert-info -sd -ed -f /etc/grid-security/hostcert.pem
	   Jan 21 12:24:48 2003 GMT
	   Jul 15 11:30:57 2020 GMT

       Display the subject of a certificate in both the default and the RFC 2253 forms.

	   % grid-cert-info -subject
	   /DC=org/DC=example/DC=grid/CN=Joe User
	   % grid-cert-info -subject -rfc2253
	   CN=Joe User,DC=grid,DC=example,DC=org

ENVIRONMENT VARIABLES

       The following environment variables affect the execution of grid-cert-info:

       X509_USER_CERT
	   Path to the default certificate file to inspect.

AUTHOR

       University of Chicago

Globus Toolkit 5.0.1						    03/22/2010							 GRID-CERT-INFO(1)