| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
currency and time calculation
Hi
I have total hours pr week Total hours = B5 time format hours rating =B2 $$$$ currency format I NEED TO TOTAL AMMOUNT TO BE PAYED =C5 I HAVE TRIED =B5*B2 but i cant have the right calculation what can i do to calculate currency and time together |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
currency and time calculation
=B5*24*B2
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tia" wrote in message ... Hi I have total hours pr week Total hours = B5 time format hours rating =B2 $$$$ currency format I NEED TO TOTAL AMMOUNT TO BE PAYED =C5 I HAVE TRIED =B5*B2 but i cant have the right calculation what can i do to calculate currency and time together |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop time - start time calculation | Excel Worksheet Functions | |||
| Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) | |||
| multiply time and currency | Excel Worksheet Functions | |||
| Figure time multiplied by currency | Excel Worksheet Functions | |||
| add time and convert it to currency | Excel Worksheet Functions | |||
![Tia[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
