Striped Lightning uses the start and stop times in most datasets to get
delta hours for any given record. As such, if a work order or person is
logged in the system before midnight and the clock rolls to a new day the
accumulated hours keep incrementing until forced or normal logout occurs.
This results in jobs with logout times greater than 23:59. To get the
correct stop time (and only stop times will be greater than 24:00 by the
way) you must check to see if the value is greater than 23:59 and if so
then subtract 24 hours.




John Minkkinen
Senior Programmer/Analyst
Flow Products, Inc.



 -----Original Message-----
From: Tom Ducharme
Sent: Monday, May 01, 2000 1:50 PM
To: John Minkkinen
Subject: FW: Golden Oldie - Striped Lightning


YOU MIGHT WANT TO ANSWER THIS.

 -----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
Behalf Of Chip Dorman
Sent: Saturday, April 29, 2000 8:36 AM
To: [log in to unmask]
Subject: Golden Oldie - Striped Lightning


Hi y'all,

I received this question on Friday afternoon.  Does anyone remember
what time format Striped Lightning used?

> Chip,
> We are still using Striped Lightning and I am currently trying to write
a report
> that will report work order sequence start and stop times.   What
format does
> Striped Lightning store these times items in?  They seem to be in
military time
> but yet they commonly exceed the 24 hr limitation by more that 24 hrs.
 Any help
> would be much appreciated since there is very little in the manual that
alludes
> to the accessing of time information outside the SL system.
> Jeff

TIA,
Chip Dorman
Greenfield Industries/KMT