Timecard question
 

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

Timecard question
 

=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

Timecard question
 

In D8 try

=D6*D7*24

VBA Noob


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

Timecard question
 

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

Timecard question
 

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" wrote in message
...
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

Timecard question
 

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



"VBA Noob" wrote:

In D8 try

=D6*D7*24

VBA Noob


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