5

I was entering timesheet data (in minutes) into an Excel spreadsheet. Then the requirements changed - the data actually needs to be in hours. Is there a way to divide all the cells by 60 in place without using formulas? Ideally, I'd like to select all the cells and somehow say "Divide by 60."

Note: I've answered my own question in the hopes that others might find it useful (or provide a better solution!).

7

It turns out you can do exactly what I wanted:

  1. Enter the number 60 into another cell, doesn't matter where.
  2. Copy that cell (ctrl-C).
  3. Select the cells you want to modify.
  4. Right-click, paste special.
  5. You get some options of what operation you want to apply. I picked Divide for my case.
  6. Magic! All the selected cells' values are now divided by 60. You can even delete the cell you used for the number 60.
  • Looks like that if you didn't post your question there would be no need to ask it, since you found the answer in a matter of seconds. :o) – Mario Marinato Jul 6 '11 at 21:03
  • 2
    @Mario, yeah I was trying to follow the SE guidelines of "pretend you're on Jeopardy" when answering your own question. I had already found the solution and thought others might benefit from it. – Kristo Jul 6 '11 at 21:51
  • Self-answering is fine on these sites. – Lance Roberts Jul 6 '11 at 22:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.