LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
TeddyBearDJ
 
Posts: n/a
Default calculating payroll

I need the formula to calculate hours into dollars.
For instance, here is the format for hours. [h]:mm
When I try to calculate how much money that is, it doesn't come out right.
so lets say that a1 is 80:00, using the format listed above,
Then B1 should be A18*10.00(rate of pay per hour)
When I do the obvious, A1*10.00 it comes up with $33.33. Thats obviously
not right. What format is the answer box supposed to be to calculate right?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 05:49 PM
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! RICHARD Excel Discussion (Misc queries) 0 March 1st 05 01:53 PM
payroll calculator for ontario canada, cant convert ontario rates. sue Excel Discussion (Misc queries) 1 January 29th 05 10:39 PM
payroll calculator for ontario canada, cant convert ontario rates. sue Excel Discussion (Misc queries) 0 January 29th 05 09:33 PM
Calculating commission schedule (will pay for help!) bootsy Excel Worksheet Functions 2 October 28th 04 07:24 AM


All times are GMT +1. The time now is 02:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"