Take the 2-minute tour ×

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!).

share|improve this question

1 Answer 1

up vote 3 down vote accepted

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.
share|improve this answer
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 -br- Jul 6 '11 at 21:03
@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


