if % entry is in c3
enter in d3 =c3*0.8
i.e 25 *0.8=20

--
Greetings from New Zealand
Bill K
"BaffledFloridaExcelUser"
wrote in message
...
I'm trying to make the company records more managable.
Timesheets currently show percentage of time spent each two weeks on a
project.
One work week = 40 hrs.
If someone is showing 25% of their time spent on "Sponsorship" I'd like to
type 25 into the cell, and have the number "20" pop up (as in 20 hrs spent
over 2 weeks). The company uses 5% increments.