How can I calculate rate per hour in a spread sheet?

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi,
I have one column (I3) that equals the total hours worked and is created by
subtracting the starting time from the ending time and another column (K3)
that has the total amount earned. I'd like to create a third column that
divides the total amount earned by the total time worked, but it doesn't
seem to work when I use the =sum(K3/I3) function. Can you tell me how to do
it?
Thanks
 
Jeff,

I'm not sure what your formula is trying to do.

SUM needs a range to aggregate (or a single cell - but
that's a bit useless).

Remove the SUM from your formula and see what K3/I3 gives
you.

HTH
Fred
 
Hi

=K3/I3/24
Format as decimal or currency.
(This is because 1 is one day, 24 hours, in Excel. So 1 hour is 1/24, not
1.)
 
Hi Jeff!

I think you have a problem of conversion of elapsed time in Excel's
date / time system.

G3: 9:00
H3: 15:00
I3: =H3-G3
Returns 6:00
K3: 400
L3: =K3/I3
Initially returns 0:00

But time is recorded by Excel as a decimal part of one day.
To get the rate per hour use:

L3: =K3/(13*24)
Initially returns 16:00
Format as General returns 66.66667

Which is correct: $66.67*6 = 400



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Jeff!

Thanks for thanks and it always helps searchers if a solution is known
to work. In this case I think the clues are the appreciation of how
Excel handles time plus the formatting issue:

=K3/(I3*24) returning 16:00 is pretty confusing!!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top