Hello all,
I currently have a range of cells I14:BV900, with some of the cells containing times in minutes simply in the format of a number ie. 70 not 1:10. Is it possible to write a macro that says
FOR Range I14:BV900
DIVIDE each individual cell within above range by 60 and output to 3 decimal places in the same cell as before.
(so if for example 20 was in I15 and the macro was run when a button in the spreadsheet is clicked it would then show 0.333 afterwards)
Cheers for everything you do guys, learning quick but would be very stuck without this forum sometimes!
David
Bookmarks