calculating time (for payroll)

[al_rwli]

I'm trying to use Excel like a "time clock" to check in/out of work. I
want to be able to write the time in a certain cell that I came into
work, left for lunch, came back from lunch, and left for the day. I
then want to add up the hours for the week and any hours up to 45 I
need to multiply by a dollar amount. Also, any hours above 45 I need
to calculate for overtime.
I can add the ours to get a total for the week but am having a hard
time with multiplying "Time" by a dollar ammount. (Nevermind that I
have to find the amount of hours overtime) Attached is a very simple
sample of what I want it to look like. Please help.

Attachment filename: timesheet sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=396137

 

[Bob Phillips]

You are probably experiencing the fundamental time problem, that is that it
is held as a fraction of 1 day. Thus, when you want to get dollar amounts,
you need to multiply by 24 as well as by the hours and the amount.

To get the basic and overtime hours, use these formulae
G13: =MIN(SUM(B12:G12),45/24)
G14: =SUM(B12:G12)-G13
H13: =G13*10*24
H14: =G14*15*24


--

HTH

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

 

[Ron]

This should get you started:
Put this in F14

=G14*10*24

Ron