| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for payment, time vs hourly price
Hi
I have a sum of times, as of now 0:25 (25 mins) and a price at 30. The price for the work is 12.5, 25mins / 60mins * 30 ..... how do I implement that formula? WBR Sonnich |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula for payment, time vs hourly price
Hi,
Am Mon, 19 Sep 2011 06:53:56 -0700 (PDT) schrieb Sonnich Jensen: I have a sum of times, as of now 0:25 (25 mins) and a price at 30. The price for the work is 12.5, 25mins / 60mins * 30 ..... how do I implement that formula? Time * 24 * Price Time in A1, price in B1: =A1*24*B1 Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula for payment, time vs hourly price
On Sep 19, 5:14*pm, Claus Busch wrote:
Hi, Am Mon, 19 Sep 2011 06:53:56 -0700 (PDT) schrieb Sonnich Jensen: I have a sum of times, as of now 0:25 (25 mins) and a price at 30. The price for the work is 12.5, *25mins / 60mins * 30 ..... how do I implement that formula? Time * 24 * Price Time in A1, price in B1: =A1*24*B1 Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 Thanks, it works |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a time value in an Excel formula to figure an hourly average | Excel Discussion (Misc queries) | |||
| Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
| How to convert half hourly data into hourly | Excel Discussion (Misc queries) | |||
| How do I sample hourly data one time per day | New Users to Excel | |||
| create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) | |||
Linear Mode
