| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to calulate wages
I have a hours in A1 (formatted [hh]:mm) and a rate in £ in A2. In A3 I have
A1*A2 to give total of wages. I have tried formatting in [hh]:mm and number but cannot get it to work any suggestions |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to calulate wages
Hi,
Maybe this =(HOUR(A1)+MINUTE(A1)/60)*A2 Format as general Mike "Stuart WJG" wrote: I have a hours in A1 (formatted [hh]:mm) and a rate in £ in A2. In A3 I have A1*A2 to give total of wages. I have tried formatting in [hh]:mm and number but cannot get it to work any suggestions |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to calulate wages
Hi Mike
Works great. However the calculation does not work if hours are 24 or more. Any suggestions Stuart "Mike H" wrote: Hi, Maybe this =(HOUR(A1)+MINUTE(A1)/60)*A2 Format as general Mike "Stuart WJG" wrote: I have a hours in A1 (formatted [hh]:mm) and a rate in £ in A2. In A3 I have A1*A2 to give total of wages. I have tried formatting in [hh]:mm and number but cannot get it to work any suggestions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calulate the weighted average | Excel Discussion (Misc queries) | |||
| Excel Formula to calculate wages | Excel Worksheet Functions | |||
| A Formula For A Wages Book | Setting up and Configuration of Excel | |||
| HOW DO I CALULATE A OVERTIME FORMULA | Excel Worksheet Functions | |||
| Lookup formula for wages, add in another? | Excel Discussion (Misc queries) | |||
![Stuart WJG[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
