Multiplying Minutes by a Number then a Currency Value

[Dazzybeeguy]

Can anyone let me know how best to do the following.

If I have say 45 minutes displayed in a cell (A1) I want to multiply that by say 1000 (in cell B1) and display answer in hours, then multiply that by an hourly rate of say £15 (Cell C1)

How should I format cells A1 & B1 etc

Thanks

 

[Alex Blakenburg]

It is going to depend on what you have in A1. Is it just a number of minutes entered (eg 45) or is it a time value version of minute entered eg hh:mm / 00:45.
You also need to take into account at what point you want the figures to be rounded eg when converting to hours, after multiplying by the rate OR both.

Book1
	A	B	C	D
1	0:45	750.00	15.00	11,250.00
2	[h]:mm	Numeric 2 decimals	Numeric or currency 2 decimals	Numeric or currency 2 decimals
3				=b*c
Sheet1

Cell Formulas
Range	Formula
B1	B1	=A1*24*1000
D1	D1	=ROUND(B1*C1,2)