Turning percentages into minutes

Hhi kle5

New Member
Joined
Jun 13, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
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
    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.

Toadstool

Well-known Member
Joined
Mar 5, 2018
Messages
2,199
Office Version
  1. 2016
Platform
  1. Windows
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
Joined
Nov 7, 2011
Messages
1,854
Office Version
  1. 2013
  2. 2007
Platform
  1. Windows
@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?

Please be more specific.
 

Hhi kle5

New Member
Joined
Jun 13, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
@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?

Please be more specific.
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
Joined
Nov 7, 2011
Messages
1,854
Office Version
  1. 2013
  2. 2007
Platform
  1. Windows
Your response didn't answer either of my questions.

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
Joined
Nov 7, 2011
Messages
1,854
Office Version
  1. 2013
  2. 2007
Platform
  1. Windows
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)
 

Forum statistics

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

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top