Date Time Field

Giganews Newsgroups
Subject: Date Time Field
Posted by:  SJC
Date: Thu, 18 May 2006

Is there a way to make the cost column do the following with a formula?

Start                          Cost
4/1/06 6:45 AM          $10
4/1/06 7:00 AM          $8
4/1/06 7:15 AM          $6
4/1/06 6:00 PM          $10
4/1/06 6:15 PM          $8
4/1/06 6:30 PM          $6
4/1/06 6:45 PM          $6
4/1/06 7:00 PM          $6
4/1/06 7:15 PM          $6
4/2/06 6:45 AM          $10
4/2/06 7:00 AM          $8
4/2/06 7:15 AM          $6
4/2/06 6:00 PM          $10
4/2/06 6:15 PM          $8
4/2/06 6:30 PM          $6
4/2/06 6:45 PM          $6
4/2/06 7:00 PM          $6
4/2/06 7:15 PM          $6
4/3/06 6:45 AM          $10
4/3/06 7:00 AM          $8
4/3/06 7:15 AM          $6
4/3/06 7:30 AM          $6
4/3/06 7:45 AM          $6
4/3/06 6:00 PM          $10
4/3/06 6:15 PM          $8
4/3/06 6:30 PM          $6
4/3/06 6:45 PM          $6
4/3/06 7:00 PM          $6
4/3/06 7:15 PM          $6
4/3/06 7:30 PM          $6

Basically I need to assign $10 cost to the first occurence in the AM and $10
cost to the first occurence in the PM.  Then, I have to assign $8 cost to the
second occurence in the AM and $8 cost to the second occurence in the PM.
Then, I have to assign $6 cost to every occurence 3rd, 4th, or so on.

Replies