# Turning percentages into minutes

#### Hhi kle5

##### New Member
Having a hard time understanding some of this stuff. I'm trying to figure out how to turn the percentage of hours works into minutes. What formula can I put in cell D to calculate that? Any help would be appreciated.

#### Attachments

• Screenshot_20210613-203714.png
158.3 KB · Views: 8

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

##### Well-known Member
Hi Hhi kle5,

I see you are holding the hours as decimal hours which makes it easier (so 3.76 is 3 hours 45 minutes and 36 seconds). So to calculate 4.25% of 3.76 hours then multiply by 60 to convert hours to minutes, then multiply by the percentage.

Hhi kle5.xlsx
ABCD
1NameHoursBreakMinutes
2Jane3.764.25%9.59
3John105%30.00
4Sue110%6.00
5Jim1.520%18.00
Sheet1
Cell Formulas
RangeFormula
D2:D5D2=(B2*60)*C2

#### johnnyL

##### Well-known Member
@Hhi kle5 Are you wanting to know what the column C percentages equates to in minutes of an hour and store that result in Column D?

Or do you want Column C percentages converted to minutes of an hour and then subtracted from Column B, then store that result in Column D?

#### Hhi kle5

##### New Member
@Hhi kle5 Are you wanting to know what the column C percentages equates to in minutes of an hour and store that result in Column D?

Or do you want Column C percentages converted to minutes of an hour and then subtracted from Column B, then store that result in Column D?

Yes. I want to know the the minutes of lets say 4.35 hours and break is 3.76% turning the percentage into minutes.

#### johnnyL

##### Well-known Member

Your response sounds like you want to convert the B column to minutes, add that to the C column converted to minutes, and store that sum into the D column. Is that correct?

#### johnnyL

##### Well-known Member
If my last question is correct then:

Book1
ABCD
1namehoursbreakminutes
2jane3.764.25%228.15
3john510%306
Sheet1
Cell Formulas
RangeFormula
D2:D3D2=(B2 * 60) + (C2 * 60)

Replies
5
Views
84
Replies
3
Views
87
Replies
2
Views
127
Replies
1
Views
326
Replies
3
Views
246

1,148,276
Messages
5,745,806
Members
423,976
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back