Home |
Search |
Today's Posts |
#1
|
|||
|
|||
time conversion
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 |
#2
|
|||
|
|||
Hi Steane,
=SUMIF(B4:B200,B8,K4:K200)/24/60 and format as time -- HTH RP (remove nothere from the email address if mailing direct) "Steane" wrote in message ... 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 |
#3
|
|||
|
|||
Hi Bob,
You beaut, works a treat. Makes sense when you step back and look at it. I could format the cells to h:mm after modifying the formula. Many thanks, Steane "Bob Phillips" wrote: Hi Steane, =SUMIF(B4:B200,B8,K4:K200)/24/60 and format as time -- HTH RP (remove nothere from the email address if mailing direct) "Steane" wrote in message ... 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 |
#4
|
|||
|
|||
Hi Bob,
You beaut, it worked a treat. It makes sense when you sit back ot look at it. I could format the cell to h:mm after modifying the formula. Many thanks, Steane "Bob Phillips" wrote: Hi Steane, =SUMIF(B4:B200,B8,K4:K200)/24/60 and format as time -- HTH RP (remove nothere from the email address if mailing direct) "Steane" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheets | New Users to Excel | |||
Time Conversion question | Excel Discussion (Misc queries) | |||
Adding time | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions | |||
Excel Time Conversion | Excel Discussion (Misc queries) |