Can Excel turn % hrs worked/week put in a cell into a real number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need formula to prevent typing in duplicate numbers 1
SUMPRODUCT formula help?? 1
To find out the total number of hrs worked in a week 2
Number of hrs worked in a week, based on dates in a different column 1
How can I break up a worksheet into weeks? 3
Excel Excel: sum of 7 cells (weeks) in every row of a spreadsheet 1
How do I calculate time in excel (clock in and clock out 3
Convert all cells in a column from hrs into mins 1

Back
Top