Solved
Contributor
Posts: 42

# Time interval in seconds

Have:

 START DATE START TIME END DATE END TIME ID01 12/7/2013 10:00:00 12/8/2013 10:00:00 ID02 12/7/2013 9:00:00 12/8/2013 9: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
Esteemed Advisor
Posts: 5,521

## 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

All Replies
Solution
‎12-08-2013 02:39 PM
Esteemed Advisor
Posts: 5,521

## 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,852

## 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 and locked.

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

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