Re: Difference between 2 time values expressed in hh:mm:ss format

Ooooh - good AND clever answer
MUST remember that one



Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill



BMay@xxxxxxxxx
Sent by:
rpg400-l-bounces@ To
midrange.com RPG programming on the IBM i /
System i <rpg400-l@xxxxxxxxxxxx>
cc
05/24/2010 10:26
AM Subject
Re: Difference between 2 time
values expressed in hh:mm:ss format
Please respond to
RPG programming
on the IBM i /
System i
<rpg400-l@midrang
e.com>






Use the %Diff Bif to get the difference in seconds. Then add the seconds
to a time field set for midnight (00:00:00).

Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi



Jeff Young <cooljeff913@xxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
05/24/2010 08:59 AM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

Subject
Difference between 2 time values expressed in hh:mm:ss format






Is there an easy method to do this?
I have 2 time fields: 10:05:20 and 10:03:05.
I would like to get the difference for reporting between the 2 times in
00:02:15 (hhmmss).
The %Diff bif will return the differnece in *Days, *Min or *Sec.
Given that, how can I get the result in the desired format.

Thanks,

Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions
V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions
Designer V5R3
IBM Certified Specialist- e(logo)server i5Series Technical
Solutions Implementer V5R3
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.