Time Extraction

[Anonymous]

Dear all,

I am having a field say TimeStamp which stores intime(AM) and outime(PM) of a person.

Sample:   PersonName  TimeStamp

                  ABC             8:35:02 AM

                  ABC             5:32:04 PM

I want to represent TimeStamp filed into two fields say InTime and OutTime w.r.t person.

Format:          PersonName        InTime            OutTime

                       ABC              8:35:02 AM          5:32:04 PM

Reply me ASAP.

Regards,

Balraj Ahlawat

[CELAMBARASAN]

Considering you have 2 tables with fields : PersonID, Person,Department etc.

2nd one with PersonID, Date, Time

Here Im going to create a additional table with primary key as PersonID

Load

     PersonID,

     Date,

     Min(Time) AS InTime,

     Max(Time) AS OutTime

Resident TimeTransaction table // 2nd table name

Group By PersonID, Date;

Hope it helps