Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
payroll calculator for ontario canada, cant convert ontario rates. | Excel Discussion (Misc queries) | |||
payroll calculator for ontario canada, cant convert ontario rates. | Excel Discussion (Misc queries) | |||
Calculating commission schedule (will pay for help!) | Excel Worksheet Functions |