ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   formula for payment, time vs hourly price (https://www.excelbanter.com/excel-programming/444960-formula-payment-time-vs-hourly-price.html)

Sonnich Jensen

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

Claus Busch

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

Sonnich Jensen

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



All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com