Steve Ironmonger
New User
Joined: 19 Oct 2015 Posts: 15 Location: UK
|
|
|
|
Just wondering if this is possible.
I'm trying to calculate the difference between two times (i've created the times in a REXX so I can format them any way I want)
Basically my data looks like this
Code: |
Cust Num,Date,Start Time,End Time
000000426,20160802,16:54:30,0009,17:02:28 |
I want to calculate the difference between the 2 times and create a file that contains the following :-
Code: |
Cust Num,Date,Start Time,End Time
000000426,20160802,16:54:30,0009,17:02:28,00:07:58 |
I.e. the difference between the end time and the start time
I can do what I want in excel or in the rexx, I'd rather not do it in the rexx as the job is going to run daily and there will be several 100,000 records to process and I don't want capacity & performance on my back about how much CPU my job is using !
Any help or ideas would be greatly appreciated. |
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
No end date? Jobs running for longer than 24 hours will be incorrect.
Jobs starting before midnight, ending after midnight complicate things. Identical start and end times could occur? Would they be less than one second, or exactly 24 hours?
If you can do seconds since midnight in your Rexx, it would make things easier. You'd still have some calculation to get hours and minutes. |
|