Timecard formulas

[josiecottn]

How can I get Excel to take the overtime from one cell? For instance:
10:00 hours worked. 8:00 will be regular, and 2:00 will be overtime.
Aside from regular subtraction (10-2) is it possible to use a question?
ie: if cell a1 (10 hours) is greater than 8 then (that number entered
into the overtime column)?

 

[Bob Phillips]

Josie,

Assume time is in A1

=MAX(0,A1-8)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[js]

=if(a1>8,a1-8,"")

 

[Jordon]

How can I get Excel to take the overtime from one cell? For instance:
10:00 hours worked. 8:00 will be regular, and 2:00 will be overtime.
Aside from regular subtraction (10-2) is it possible to use a question?
ie: if cell a1 (10 hours) is greater than 8 then (that number entered
into the overtime column)?

http://www.cpearson.com/excel/overtime.htm