In a spread sheet I have a group of cells, b4 thru b34 that represent
minutes but are entered as single digits. Example - b4 = 35, b5 = 15,
b6 = 55 and so on.
The entry cells are formatted as custom - 00. That way if I have an
entry of 5 or 0 it will read 05 or 00.
I need a formula that will give me the total of all these cells and
convert it into minutes.
If I have a total of 285 it should read 45 as in :45. I have tried
sum(b4:b34)/60 but it doesnt work on any formats.

What would be a good solution if there is one.
Thanks for any help.