you can't really have one where you enter 10 and it changes to 8 and 2 in
an extra column - well you can but it's not the easiest way to work with
the data

Best to have at least

A1 "Hours Worked"
B1 "Normal"
C1 "Overtime"
Then enter data in A2, A3 etc
with the following formula in B2 and C2

B2 = min(A1,8) ie if you work less it shows the correct hours
C2 = max(A1,8)-8 ie the number of hours more than 8
The formula in B2 and C2 can be copied down as you enter more data

Steve

On Mon, 21 Aug 2006 23:33:35 +0100, KimC
wrote:

I have set up a time sheet for employees to fill out on the computer. I
need
one column (STRAIGHT TIME) to total up to 8 hours ONLY, and anything
beyond
that to go in the OVERTIME column. So in other words, if I work 10 hours
in a
day, I need Excel to automatically record 8 hours in the straight time
column, and 2 hours in the overtime column. I can't find what formulas
to use
to make this happen automatically upon entering the hours worked.