Sergejack said: 1. Begin time of any activity stick to the end of the 30m span. 2. End time of any activity stick to the begining of the 30m span. What about "if begin/end time of an activity cann't be definitely infered from other log records, th

Sorry, " However, it is not possible to have two appointments that starts and ends within the span of 30 minutes." is really from FAQ 7.

= 'Actual Duration'. Or I'm missing something :)

FAQ 8 :" However, it is not possible to have two appointments that starts and ends within the span of 30 minutes." What about 9:00 to 10:05 Activity1, 10:05 to 10:25 Activity2, 10:25 to 10:55 Activity3 ? I guess it's not possible too. I.e. no two ap

Sebastian, "2. The length of the first three lines of each recrd will always be the same and will be divisible by three." " #2 - There may be spaces (leading or trailing) in the string values." Do you mean the spaces (leading or trailing) are n

012 345 678 X90 867 716 ' _ _ _ _ _ _ _ _ _ _ _ _ _ _ | | | _| _||_||_ |_ ||_|| ||_|| ||_||_ | | ||_ |_| ||_ _| | _||_| ||_| | _||_||_||_| | | ||_| ' UNION SELECT 8, '_ ' U