This brings back an answer of 53.33... Am I doing something wrong? What is
the 24?

Thanks for your help... :)


"Teethless mama" wrote:

=SUM(D1:D5)*24*D7
format as General

"Patrick" wrote:

I have a timecard set up to calculate my par period hours, but can't figure
out how to take the total hours (say 68:00) and multiply it by the rate of
pay (say $20.00 per hour) and come up with the correct total pay ($1,360.00).
Here is how it is set up:

column d1:6 is formatted as [hh]:mm

a1 = Monday; b1 = start time (9:00 AM); c1 = end time (5:00 PM); d1 = total
daily hours (8:00)
a2 = Tuesday; b2 = start time (9:00 AM); c2 = end time (5:00 PM); d2 = total
daily hours (8:00)
a3 = Wednesday; etc...
a4 = Thursday; etc...
a5 = Friday; etc...

d6 = total weekly hours (40:00) =SUM(d2:d5)
d7 = rate of pay ($20.00) formatted as accounting
d8 = total pay ($800.00) formatted as accounting

The problem arises when I try to multiply d6 and d7. d8 actually arrives at
$28.33 instead of the $800.00 that it should be.

Is there a way of resolving this?

Thanks