Date:         Fri, 4 Aug 2006 17:08:00 -0400
Reply-To:     Edward Boadi <eboadi@abhct.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Edward Boadi <eboadi@abhct.com>
Subject:      Re: Elapsed Time Calculation
Comments: To: Shannon Deike-Sims <ansld1@uaa.alaska.edu>
Content-Type: text/plain; charset="iso-8859-1"

The first syntax was too convoluted .
If t1 and t2 and the  original 2 time variables, you can convert
you data to the required format using the syntax below.
You can then proceed to use Raynald's syntax.

COMPUTE time1=NUMBER(REPLACE(t1,":",""),F6.00) .
COMPUTE time2=NUMBER(REPLACE(t2,":",""),F6.0)  .
EXECUTE.

Have a nice weekend.
Regards.

Edward.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Shannon Deike-Sims
Sent: Friday, August 04, 2006 3:37 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Elapsed Time Calculation


Dear Listers,



I have reviewed the archives and visited Raynald's www.spsstool.net
<http://www.spsstool.net/>  website to find elapsed time syntax. I did
find the syntax from
(http://www.spsstools.net/Syntax/DatesTime/CaculateNumberOfMinutes.txt)
to be helpful and almost what I need. The format of my data is different
in that it has the semicolon in the time and I am not sure how to change
the syntax to fit my data.



Sample of my data



1 20:05 22:40

2 . .

3  2:15  6:40

4 19:34 23:05

5 . 10:05

6 .  6:12

7 16:10 17:45

8  7:35 11:57

9  3:22  7:07

10 19:47 23:37

11 . 12:55

12 22:00  1:07

13 18:55 20:25

14 10:20 13:37

15 15:20 19:38

16  9:06 12:27

17  0:45  2:55

18 16:30 18:28

19 13:35 14:05

20  9:35 .

21  5:54  9:18



I would appreciate any additional help on the elapsed time calculation.



Shannon Deike-Sims

ansld1@uaa.alaska.edu