Converting time to different denomination...

Hello Matt,

You shouldn't need a macro, you can just divide all the times by 60.

Try this

Put 60 in a blank cell then copy that cell

Select range of times and then right-click and use

Paste Special > Divide > OK > ESC

now format times as required