Help with "Timecard" calculation

[Evan Platt]

Hello all..

I'm looking for some help with a timecard. I have 4 cells, In, Out,
In, Out. (start, lunch, back from lunch, end of day). A typical entry
would be 7:30, 11:00, 12:00, 4:30. This should be 8 as the 'sum'. I'm
probably missing the obvious, but what would the formula be for this?
I've seen a number of help documents mentioning multiplying the sum by
24, but this doesn't seem to work

I doubt this is possible, but we have additional columns - regular
hours, and overtime hours. Is it possible for excel to only put a
maximum of 8 in the regular hours column, and anything over 8 in the
OT column? If not, I can simply then once I know the hours are say
9.4, put 8 in the regular hours column and 1.4 in the OT myself...

Thanks.

Evan

 

[Bob Phillips]

Evan,

Normal hours
=MIN(((B1-A1)+(D1-C1))*24,8)

Overtime hours
=MAX(((B1-A1)+(D1-C1))*24-8,0)

--

HTH

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

 

[Evan Platt]

Evan,

Normal hours
=MIN(((B1-A1)+(D1-C1))*24,8)

Overtime hours
=MAX(((B1-A1)+(D1-C1))*24-8,0)

Thanks. That did the ticket. Too bad I was just laid off today.

Evan