I'm trying to write a formula so that if say e3's value is 200, f3 will recognise that this is 60*3 +20 and will display "3.20".
Basically I'm trying to convert any size of minutes entered into hours and minutes in the cell adjacent to it. If anyone could help I'd be really grateful.
Bookmarks