Formula with time

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

If I have 0:49 minutes in a cell, the number of hours John worked,
and adjacent is $158, the amount John sold; how would I construct a
formula to find out how much John would have sold on an hourly basis?
 
Let's do it with the numbers you have:

= 158 / 49 * 60

to give $193.47 per hour.

Now, put 158 in A1, 0:49:0 in B1, and this formula in C1:

=A1/B1/24

The reason for /24 rather than *60 is due to how Excel handles times -
as fractions of a 24-hour day.

Hope this helps.

Pete
 
=B1/(A1*24)

where B1 is the amount, A1 the time.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top