Timecard question

P

Patrick

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
 
P

Patrick

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

Thanks for your help... :)


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

Patrick said:
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
 
D

David Biddulph

What you are doing wrong is not multiplying by 24. If you multiply your
53.33 by 24 you get 800. There are 24 hours in a day, and Excel's time
format is in fractions of a day.
--
David Biddulph

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

Thanks for your help... :)


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

Patrick said:
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
 
P

Patrick

Well it all sounds so simple now... Thanks it's working fine now.



VBA Noob said:
In D8 try

=D6*D7*24

VBA Noob

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top