Revenue per hour

[greenparrot]

hi guys

i am stuck

trying to calculate Revenue against man hours

Hours A1 Revenue B1

90:35:00 £46561.00


basically want to divide the revenue into the hours


any help would be greatly apprieciated!

regards

GP

 

[Richard Schollar]

Hi

Assuming hours in A1 and revenue in B1 and you want revenue per hour then:

=B1/(A1*24)

24 being the number of hours in a day.

 

[greenparrot]

wow simple, many thanks