Time interval in seconds

Accepted Solution Solved
Reply
Contributor
Posts: 42
Accepted Solution

Time interval in seconds

Have:

START DATESTART TIMEEND DATEEND TIME
ID0112/7/201310:00:0012/8/201310:00:00
ID0212/7/20139:00:0012/8/20139:00:00

Want:three more new variables START, END, Time interval from START to END in seconds

START DATE

START TIME

START

END DATE

END TIME

END

Time Interval in Seconds

ID01

12/7/2013

10:00:00 AM

12/7/2013 10:00:00 AM    

12/8/2013

13:00:00 pm

12/8/2013 13:00:00 pm

??

ID02

12/7/2013

9:00:00 AM

12/7/2013 9:00:00 AM

12/8/2013

16:00:00 PM

12/8/2013 16:00:00 pm

??

Thanks!


Accepted Solutions
Solution
‎12-08-2013 02:39 PM
Respected Advisor
Posts: 4,659

Re: Time interval in seconds

start = dhms(start_date,Hour(start_time), Minute(start_time), Second(start_time));

end = dhms(end_date,Hour(end_time), Minute(end_time), Second(end_time));

interval = intck("SECOND", start, end);

PG

PG

View solution in original post


All Replies
Solution
‎12-08-2013 02:39 PM
Respected Advisor
Posts: 4,659

Re: Time interval in seconds

start = dhms(start_date,Hour(start_time), Minute(start_time), Second(start_time));

end = dhms(end_date,Hour(end_time), Minute(end_time), Second(end_time));

interval = intck("SECOND", start, end);

PG

PG
Contributor
Posts: 42

Re: Time interval in seconds

Thanks!

This is so quick and awesome.

It's working!!!

Respected Advisor
Posts: 3,777

Re: Time interval in seconds

I would skip all those extra functions as arguments to DHMS.

   s = dhms(sdate,0,0,stime);
   e = dhms(edate,0,0,etime);
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 184 views
  • 1 like
  • 3 in conversation