Time and Percentage Calculations

%3CLINGO-SUB%20id%3D%22lingo-sub-2377621%22%20slang%3D%22en-US%22%3ETime%20and%20Percentage%20Calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2377621%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3ENew%20to%20the%20forum.%26nbsp%3B%20Please%20be%20gentle...%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20add%20a%20factor%20to%20the%20time%20reported%20in%20my%20timesheets.%3C%2FP%3E%3CP%3EThe%20timesheet%20has%20duration%20worked%20on%20each%20task%20in%20one%20column%20(A)%2C%20expressed%20as%20HH%3AMM%3ASS%2C%20e.g.%2000%3A19%3A00.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%20another%20column%20(B)%20that%20calculates%20a%20percentage%20of%20that%20time%2C%20which%20itself%20is%20a%20calculation.%20So%20for%20example%2C%20if%20the%20percentage%20calculation%20was%2010%25%2C%20the%20result%20would%20be%20114%20seconds%2C%20or%2000%3A01%3A54%20expressed%20as%20duration%2C%20of%2000%3A19%3A00.%3C%2FP%3E%3CP%3EI%20then%20want%20to%20add%20column%20A%20to%20column%20B%20to%20get%20a%20total.%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2377621%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2377650%22%20slang%3D%22en-US%22%3ERe%3A%20Time%20and%20Percentage%20Calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2377650%22%20slang%3D%22en-US%22%3EOf%20course...%20As%20soon%20as%20I%20post%20something...%20I%20have%20worked%20it%20out.%3C%2FLINGO-BODY%3E
New Contributor

Hello

New to the forum.  Please be gentle...

I am trying to add a factor to the time reported in my timesheets.

The timesheet has duration worked on each task in one column (A), expressed as HH:MM:SS, e.g. 00:19:00.

I would like to create another column (B) that calculates a percentage of that time, which itself is a calculation. So for example, if the percentage calculation was 10%, the result would be 114 seconds, or 00:01:54 expressed as duration, of 00:19:00.

I then want to add column A to column B to get a total.  Thanks.

3 Replies
Of course... As soon as I post something... I have worked it out.

@stevenshorter 

Let's say you have a time such as 00:19:00 in cell A2

If you want the end result in B2, enter the formula

 

=A2*110%

 

in B2. If you just want the 10% in B2, and the total in C2, enter the formula

 

=A2*10%

 

in B2, and

 

=A2+B2

 

in C2. These formulas can be filled or copied down to the rows below.

Thanks@Hans Vogelaar 

 

The column for the additional 10% is conditional, based on an 'IF' the time in column A is chargeable or not.

 

Applying =A2*10% then adding to A2 works.

 

Thanks!