Timecard question

[Guest]

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

 

[Guest]

=SUM(D15)*24*D7
format as General

 

[VBA Noob]

In D8 try

=D6*D7*24

VBA Noob

 

[Guest]

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

Thanks for your help...

=SUM(D15)*24*D7
format as General

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

 

[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

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

Thanks for your help...

=SUM(D15)*24*D7
format as General

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

 

[Guest]

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

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