time conversion frustration
 

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


--
harryhoo
------------------------------------------------------------------------
harryhoo's Profile: http://www.excelforum.com/member.php...o&userid=26363
View this thread: http://www.excelforum.com/showthread...hreadid=396366

See response in .misc.

--

HTH

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


"harryhoo" wrote in
message ...

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


--
harryhoo
------------------------------------------------------------------------
harryhoo's Profile:
http://www.excelforum.com/member.php...o&userid=26363
View this thread: http://www.excelforum.com/showthread...hreadid=396366