Calculate a Percentage of time

[dugemkakek]

Hello


Can somebody help me with this problem i'm having with, im trying to figure out how to determine Time1 is (Time2 - #%), this is an example of the problem :

im trying to get a broader percentage like 15%,16%,17% etc to 30%.
tried using a simple formula but the result is off by a large margin


This is my Formula :
(=($A2*B1)+$A2)


Example :

there's a margin of x Second in the result and the template im trying to replicate.


thanks in advance and sorry for my broken english

 

[DSCfromCFA]

G'day d

In your opening line, you say that Time1=Time2-#% but your formula calculates Time2=Time1+#%.

In the table at the top of your post, if you look at the 8:00 under the 25%, then go to the left, 6:00 is indeed 8 - 2 (25% of 8), but, if you look at your chart F2 (7:30) is 6 increased by 1.5 (25% of 6) which is why your numbers don't match - you actually have to add 33.3333% to 6 to get 8.

You need to re do your formula with different percentages to get it to use the column A time to calculate all the increases, but you are going to get some pretty weird numbers there, such as 33.333% where you currently have a nice neat 25%

shane

Edited to add - there is also the matter that using a percentage of the current time/hours means that at 6:00 o'clock/hours a 33.333% increase is 2 hours, but at 9 o'clock/hours it's 3 hours. Is this the way you wanted it to work, or did you want a consistent time increase no matter what time the percentage was applied to?

 

[FormR]

Hi, welcome to the forum!

Maybe this is what you need:

Excel 2013/2016
	A	B	C	D	E
1		18%	20%	23%	25%
2	06:00	07:19	07:30	07:44	08:00
3	06:05	07:25	07:36	07:50	08:06
Sheet1

Cell Formulas
Range	Formula
B2	=$A2/(1-B$1)