I need a formula. I need to place c "Time" in appropriate time table.
Corresponding with the appropriate date they came in.

On Sheet 1.
In Column B1:B2000 I have dates.
Columb C1:C2000 i have time" 60" meaning 60 minutes.

On Sheet 2

In Row 2. from B across to H i have names sixty minutes, 75 minutes, 90
minutes and 120 minutes.

On the right side of the table In Column P2 all the way down i have fixed
dates 1/1/08 dragged down all the way to end of year. ( i do not change
these dates.)

What i want is when i enter date in Sheet1 and the time i want to
automatically be entered coresponding in the correct column and date.
But insead of transfering the exact number ex "75" to the severyfive minutes
column and date. I want it to only count as 1.