Hi Dave,
Please send the VBA solution for me. I can't get a logic which can
solve this problem without saving "Hour Worked" values. The problem
part with me is when a new value added to data it will not show the
correct percentage value. The cause I already mentioned in previous
reply.
If MNM nee
Hi
This can't be done with worksheet functions without the use of another column,
because of circular referencing.
However, it can be done with macros, either automatically, or by button click.
So, which would you prefer: Worksheet functions with extra column, or VBA?
Regards - Dave.
> Date
Hi,
If I say clearly then this is not possible to change the "Hour Worked"
value in percentage in the same column.
The reason is that when a value is changed to percent what will
converted to a fraction.
Date User Hours Worked Hours Worked %
16-Jul ABC8
