I have a cell which displays 220:15
For internal reasons, this cell has to be formatted "Custom [h]:mm".
Now I need to calculate the number of minutes = 220*60 + 15 = 13215.
Whatever formula I'm trying does not produce the correct result... Can anyone help ?
For internal reasons, this cell has to be formatted "Custom [h]:mm".
Now I need to calculate the number of minutes = 220*60 + 15 = 13215.
Whatever formula I'm trying does not produce the correct result... Can anyone help ?