Hi,
I have a cell containing total minutes referenced from other cells using
SUMIF. I need the total converted to hours and minutes (real time not
decimal). I have tried formatting the cell to h:mm but all I get is 0.00 (the
function is still active).

=SUMIF(B4:B200,B8,K4:K200).
S11 gives the totol of 1270. How do I get the cell to show hours and minutes?

Thanks,

Steane