Prev: Formula Help - ce
Next: How to count number of sheets
From: Steve on 2 Mar 2010 19:17
I have made a timecard with excel everything is working as planned except for
one thing. I am unable to get the roper formula or function to calculate my
pay. I am not concernned with overtime being calculated just straight time. I
have 2 pay rates $27 per hour for scanning and $10 per hour for drive time.
When i enter the formula =Q21*27 I need to get the total hours to be
multiplied by $27 per hour and the formula =R21*10 to multiply the total
hours in the cell by $10 per hour but the calculations are wrong. everything
else works perfect. I will be happy to send a copy of the timecard to anyone
who can help me. Thank You



From: Peo Sjoblom on 2 Mar 2010 19:32
If you have Excel time for example 08:00 in a cell like A2 then you need to
multiply it with 24

A2*24*27

will get you $216.00



--


Regards,


Peo Sjoblom


"Steve" <steveed3(a)gmail.com> wrote in message
news:5249E002-4AAD-49EC-947F-CDCC840D8C2A(a)microsoft.com...
>I have made a timecard with excel everything is working as planned except
>for
> one thing. I am unable to get the roper formula or function to calculate
> my
> pay. I am not concernned with overtime being calculated just straight
> time. I
> have 2 pay rates $27 per hour for scanning and $10 per hour for drive
> time.
> When i enter the formula =Q21*27 I need to get the total hours to be
> multiplied by $27 per hour and the formula =R21*10 to multiply the total
> hours in the cell by $10 per hour but the calculations are wrong.
> everything
> else works perfect. I will be happy to send a copy of the timecard to
> anyone
> who can help me. Thank You
>
>
>


 | 
Pages: 1
Prev: Formula Help - ce
Next: How to count number of sheets