# Thread: Help in understanding Percentafe (1977)

1. ## Help in understanding Percentafe (1977)

I would like to understand the way percentages work in Excel formula's. Example, \$100.00 represents 8 hours pay. What would be 42 minutes (what percent of 8 hours is 42 minutes) and the resulting amount (What dollar amount does 42 minutes represent)? If cell A1 were to be the amount of pay (\$100.00) and cell A2 would be the amount of time needed to calculate (42 minutes) then cell A3 would be ?? dollars.

2. ## Re: Help in understanding Percentafe (1977)

Try

=A2/480*A1

The 480 is 60 minutes times 8hrs (There are 480 minutes in 8 hrs) 42/480 gives you the percent. Multiply this times the \$100 = \$8.75

3. ## Re: Help in understanding Percentafe (1977)

Another way of doing it is to enter the times as times.

Enter 0:42 in cell A2 and 8:00 in (say) cell A5.
The formula for the percentage would be simply =A2/A5. The result will be 0.0875, meaning 8.75%. If you want to see it as a percentage, select Format | Cells..., and select Percentage, with 2 decimals.
You can calculate the amount of dollars directly: =A1*A2/A5, or via the percentage as intermediary result: say that you enter the formula with the percentage =A2/A5 in cell A6; the formula for the amount becomes =A1*A6.

4. ## Re: Help in understanding Percentafe (1977)

Thanks Hans. I will utilize the info.

Larry

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•