View Single Post
  #1   Report Post  
BaffledFloridaExcelUser
 
Posts: n/a
Default Can Excel turn % hrs worked/week put in a cell into a real number

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.