Help req'd with Formulas...cont'd

[mgh65]

This is how i want to layout my timesheet in the excel spreadsheet (Mac
version)
Date start finish Hours overtime
11-Sep 08:00 21:00 1.00

So I don't need to actually calc total hours, just hours over 12.
so I just need a formula for the cell with the 1.00 in it to calc the
overtime hours.

Sorry if this post is confusing, but I don't understand how to apply
the formula suggested in the previous post, or how to add to the
previous post as I'm new at this web posting thing.

thanks...Mike

 

[Geoff Lilley]

Hi Mike. I know well the problem of which you speak. This is what I
would do in the "hours overtime" cell:

=((C2-B2)*24)-12

That's assuming that the "finish" is in C2, and the "start" is in B2.
Remember, subtracting one time from another is just the start. You
then want to take the result and multiply by 24. That'll give you the
actual hours. That's in the first set of parentheses from the inside.

You then take that interim result (13), and subtract 12 from it.
That'll give you whatever amount of hours exceed 12.

Hope that helps.

Best wishes,
Geoff Lilley
Microsoft Office Master Instructor (2000/XP)
Apple Certified Helpdesk Specialist