get hourly pay rate

[redspanna]

Hi all

In cell E2 I have formula to get total time worked through a range of days, this total is formatted as [h]:mm
for example if cell E2 holds value 9:23, this means total worked is 9hrs 23mins

in Cell R2 I have the actual total salary received for this same period
for example if cell R2 holds 246.04, this is the total amount received for the period.

I would like cell S2 to show me what the hourly rate would be given the total time worked vs the total amount of pay received.

for example if E2 holds the value 25.10 (total of 25hrs and 10mins worked) and R2 holds £500.00 what would the hourly rate be?

thanks in advance

 

[Marcílio_Lobão]

redspanna, Good afternoon.

Try to use:

S2 --> =R2/(E2*24)

Is that what you want?

I hope it helps.

 

[Dave Patton]

Excel 2010
	E	R	S
2	9:23	246.04	26.22
3	25:10	500.00	19.87
4
5
2e

Cell Formulas
Range	Formula
S2	=R2/(E2*24)
S3	=R3/(E3*24)

 

[redspanna]

Thanks guys - perfect

 

[Marcílio_Lobão]

redspanna,

Glad to have helped you.

Thanks for the feedback.