Hello - I've got a huge calendar of bookings and the hours are all
messed up from our database! I've got to manually fix several hundred
cells, basically changing most of them from "40" to "55", or "32" to
"44", "24" to "33", and a few others. I have Excel 2000.

I'd like to write a macro and I have a very small start. Any advice or
code would be unbelievably appreciated. Ideally I'd like to select
specific columns of cells and then run this macro pseudocode on them:

------------------------------
For each *selected* cell:
Does the cell directly to my left contain(":")?
If Yes --
Does my cell contain("40")?
If Yes --
Change my cell to ("55")
Does my cell contain("32")?
If Yes --
Change my cell to ("44")
Does my cell contain("24")?
If Yes --
Change my cell to "(33")
Does my cell contain("16")?
If Yes --
Change my cell to ("22")
Does my cell contain("8")?
If Yes --
Change my cell to ("11")
Otherwise... do nothing
If No --
do nothing

---------------------------------------------

thank you, thank you, thank you.
Jennifer.