Using Minutes and Hours

[Junior]

Hi. I have a question about converting time. In one column I have
number of minutes used and in another column I have dollars earned.
What I want to do is to determine dollars earned per hour.

Seeing as how some entries will have 0:17 minutes or 0:45 minutes and
still other cells will say 2:00 or 3:45, how do I convert time into a
usable number for hourly rate?

Ex:

Hours worked Dollars earned Hourly rate
0:20 (minutes) $10 $30
1:30 (hours/minutes) $72 $48

The reason I use the 0:20 or 1:30 time designation instead of 1/3 hour
or 1.5 hours is because that is a direct answer to time in minus time
out in two other columns.

Thanks.

Junior

 

[Bob Phillips]

Hi Junior

I think you are right to enter the worked time as time, it is more natural.

The formula you want is

=A1*24*C1

where A1 is the time,. C1 is the hourly rate

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Junior]

Hi Junior

I think you are right to enter the worked time as time, it is more natural.

The formula you want is

=A1*24*C1

where A1 is the time,. C1 is the hourly rate

Um, this formula doesn't work I don't think. I'm trying to determine
hourly rate, and this formula has hourly rate as part of the formula.

 

[Bob Phillips]

Sorry, I thought you wanted the other way. Use

=B1/A1/24

instead

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Junior]

That does the trick. Thanks much.