formula for payment, time vs hourly price

  • Thread starter Thread starter Sonnich Jensen
  • Start date Start date
S

Sonnich Jensen

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
 
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
 
Hi,

Am Mon, 19 Sep 2011 06:53:56 -0700 (PDT) schrieb Sonnich Jensen:


Time * 24 * Price
Time in A1, price in B1:
=A1*24*B1

Regards
Claus Busch

Thanks, it works
 
Back
Top