time conversion frustration

H

harryhoo

I have a cell giving total minutes (using SUMIF) and need to convert the
total into hours and minutes (real time, not decimal) for costings.

=SUMIF(B4:B200,B8,K4:K200)

the total for the cell (eg. S11) needs to be shown in hours and
minutes.

How to, please.

Cheers,

Steane Blanch
 
B

Bob Phillips

See response in .misc.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top