Date:         Thu, 16 Nov 2000 13:23:54 +0000
Reply-To:     Christian Herbé <herbe@NANCY.INRA.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Christian Herbé <herbe@NANCY.INRA.FR>
Organization: INRA
Subject:      Re: Time formatted data from SAS to Excel
Content-Type: text/plain; charset=iso-8859-1

Helan Lee a écrit :

> I have calculated the difference between the time of arrival and the time of
> drug administration and have formatted that product using the hhmm20..
> However, I am having difficulty in importing the results into Excel.  Excel
> doesn't properly read the 'Difference' results correctly in an hours and
> minutes format.

in XL97 :
Format | Cell | Personal
[H]:mm:ss


__________________________________________

Christian Herbé
Centre INRA de Nancy
EQUIPE QUALITE DES BOIS
Laboratoire d'Etude des Ressources Forêt-Bois
UMR INRA-ENGREF
54280 CHAMPENOUX (France)
Tel : 03.83.39.40 59
Fax : 03.83.39.40.69
mailto:herbe@nancy.inra.fr
___________________________________________