| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Newbie With A Question | Excel Worksheet Functions | |||
| Anybody Help with previous question | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Linear Mode
