Excel Formula to calculate wages

  • Thread starter Thread starter Angie J
  • Start date Start date
A

Angie J

What formula do I use in Microsoft Excel to calculate wages from hours
worked? I am using 2007 version.
 
Hi,

Not nearly enough information but as a start

=hrs worked * Hourly rate

would give gross pay

Mike
 
Hours x hourly rate.

If this is not sufficient detail, then perhaps you could provide some
further details yourself relating to what data you have, what columns
you are using, what you want to achieve etc.

Hope this helps.

Pete
 
Angie said:
What formula do I use in Microsoft Excel to calculate wages from hours
worked? I am using 2007 version.


That is a very generic question. Maybe if you provided examples of your data
and the result you are trying to obtain.
 
Hours worked in A1

Hourly rate in B1

=A1*B1 entered in C1

But I'm guessing there is more to your request than what you have posted.

For help on Timesheets see Chip Pearson's site.

http://www.cpearson.com/excel/overtime.htm


Gord Dibben MS Excel MVP

On Thu, 26 Feb 2009 00:34:00 -0800, Angie J <Angie
 
Back
Top