Forum Discussion
Time and Percentage Calculations
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...
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.
ThanksHansVogelaar
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!
