time conversion frustration

  • Thread starter Thread starter harryhoo
  • Start date Start date
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
 
See response in .misc.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

time conversion 3
Excel Formula for adding training times. 1
Time calcualtion in minutes 1
Excel Sumproduct 0
Daily Time Sheets with Rounding 1
Cumulative time calculation in Excel 2003 2
Time Calculation 9
SUMIF nesting ??? 3

Back
Top