Time Formula

[Guest]

I am trying to create a formula that will break down column A on sheet 1 into
3 seperate columns (A,B,C) in sheet 2. The data is setup as follows:

Sheet 1:
A
07/01/07 03:00
07/01/07 06:36
07/01/07 11:55
07/01/07 15:00
07/01/07 17:32
07/01/06 22:30

Sheet 2:
A
7a-3p (header)

B
3p-11p (header)

C
11p-7a (header)

What I'm wanting is column A, B & C on sheet 2 to show me the breakdown of 3
different work shifts, using the data from column A sheet 1.

Any help would be very much appreciated.

 

[RobinS]

Is this a .Net programming question? Or an Excel question? IF this is an
Excel question, please post it to a group with "Excel" in the description.

Robin S.