| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding time
Hello from Steved
I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
Try
=SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
Hello AKphidelt
Firstly I thankyou Now I would like to take your formula pleas to one more stage please. =SUMIF(G1:G104,"Plus",F1:F104) =SUMIF(G1:G104,"Minus",F1:F104) =SUMIF(G1:G104,"Plus","Minus",F1:F104) My objective is to now add Column but the above is not working What do I reqiure to do please to add the column using both "Plus" and "minus" ps I have some rows with "No Change" in Column G1 to G104 Thankyou. "AKphidelt" wrote: Try =SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
Try this:
=Sum(SUMIF(G1:G104,{"Plus","Minus"},F1:F104)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steved" wrote in message ... Hello AKphidelt Firstly I thankyou Now I would like to take your formula pleas to one more stage please. =SUMIF(G1:G104,"Plus",F1:F104) =SUMIF(G1:G104,"Minus",F1:F104) =SUMIF(G1:G104,"Plus","Minus",F1:F104) My objective is to now add Column but the above is not working What do I reqiure to do please to add the column using both "Plus" and "minus" ps I have some rows with "No Change" in Column G1 to G104 Thankyou. "AKphidelt" wrote: Try =SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
Hello Ragdyer
Ragdyer using your formula 1 get 7:30 Adding minus I get 9:29 and adding Plus I get 22:01 the totalling answer should be 31:30 Ragdyer What is the I'm not doind correctly please Thankyou. "Ragdyer" wrote: Try this: =Sum(SUMIF(G1:G104,{"Plus","Minus"},F1:F104)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steved" wrote in message ... Hello AKphidelt Firstly I thankyou Now I would like to take your formula pleas to one more stage please. =SUMIF(G1:G104,"Plus",F1:F104) =SUMIF(G1:G104,"Minus",F1:F104) =SUMIF(G1:G104,"Plus","Minus",F1:F104) My objective is to now add Column but the above is not working What do I reqiure to do please to add the column using both "Plus" and "minus" ps I have some rows with "No Change" in Column G1 to G104 Thankyou. "AKphidelt" wrote: Try =SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
Format the result cell as [h]:mm
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Steved" wrote in message ... Hello Ragdyer Ragdyer using your formula 1 get 7:30 Adding minus I get 9:29 and adding Plus I get 22:01 the totalling answer should be 31:30 Ragdyer What is the I'm not doind correctly please Thankyou. "Ragdyer" wrote: Try this: =Sum(SUMIF(G1:G104,{"Plus","Minus"},F1:F104)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steved" wrote in message ... Hello AKphidelt Firstly I thankyou Now I would like to take your formula pleas to one more stage please. =SUMIF(G1:G104,"Plus",F1:F104) =SUMIF(G1:G104,"Minus",F1:F104) =SUMIF(G1:G104,"Plus","Minus",F1:F104) My objective is to now add Column but the above is not working What do I reqiure to do please to add the column using both "Plus" and "minus" ps I have some rows with "No Change" in Column G1 to G104 Thankyou. "AKphidelt" wrote: Try =SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
Why not just
=SUM(F1:F104) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ragdyer" wrote in message ... Try this: =Sum(SUMIF(G1:G104,{"Plus","Minus"},F1:F104)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steved" wrote in message ... Hello AKphidelt Firstly I thankyou Now I would like to take your formula pleas to one more stage please. =SUMIF(G1:G104,"Plus",F1:F104) =SUMIF(G1:G104,"Minus",F1:F104) =SUMIF(G1:G104,"Plus","Minus",F1:F104) My objective is to now add Column but the above is not working What do I reqiure to do please to add the column using both "Plus" and "minus" ps I have some rows with "No Change" in Column G1 to G104 Thankyou. "AKphidelt" wrote: Try =SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
Not sure we are understanding your request. If G1:G104 has just Plus and
Minus then a simple Sum(F1:F104) would work. Like Bob said. "Steved" wrote: Hello AKphidelt Firstly I thankyou Now I would like to take your formula pleas to one more stage please. =SUMIF(G1:G104,"Plus",F1:F104) =SUMIF(G1:G104,"Minus",F1:F104) =SUMIF(G1:G104,"Plus","Minus",F1:F104) My objective is to now add Column but the above is not working What do I reqiure to do please to add the column using both "Plus" and "minus" ps I have some rows with "No Change" in Column G1 to G104 Thankyou. "AKphidelt" wrote: Try =SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
See last line of OP's 2nd post.<g
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bob Phillips" wrote in message ... Why not just =SUM(F1:F104) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ragdyer" wrote in message ... Try this: =Sum(SUMIF(G1:G104,{"Plus","Minus"},F1:F104)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steved" wrote in message ... Hello AKphidelt Firstly I thankyou Now I would like to take your formula pleas to one more stage please. =SUMIF(G1:G104,"Plus",F1:F104) =SUMIF(G1:G104,"Minus",F1:F104) =SUMIF(G1:G104,"Plus","Minus",F1:F104) My objective is to now add Column but the above is not working What do I reqiure to do please to add the column using both "Plus" and "minus" ps I have some rows with "No Change" in Column G1 to G104 Thankyou. "AKphidelt" wrote: Try =SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
I thankyou all.
Sum(F1:F104) Did as you all had said, My brain today is very slow today. "AKphidelt" wrote: Not sure we are understanding your request. If G1:G104 has just Plus and Minus then a simple Sum(F1:F104) would work. Like Bob said. "Steved" wrote: Hello AKphidelt Firstly I thankyou Now I would like to take your formula pleas to one more stage please. =SUMIF(G1:G104,"Plus",F1:F104) =SUMIF(G1:G104,"Minus",F1:F104) =SUMIF(G1:G104,"Plus","Minus",F1:F104) My objective is to now add Column but the above is not working What do I reqiure to do please to add the column using both "Plus" and "minus" ps I have some rows with "No Change" in Column G1 to G104 Thankyou. "AKphidelt" wrote: Try =SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
So, what you're saying, is that you want to add "Plus" and "Minus" *AND* "No
Change" ... all together. You didn't say that at the beginning, did you?<bg -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steved" wrote in message ... I thankyou all. Sum(F1:F104) Did as you all had said, My brain today is very slow today. "AKphidelt" wrote: Not sure we are understanding your request. If G1:G104 has just Plus and Minus then a simple Sum(F1:F104) would work. Like Bob said. "Steved" wrote: Hello AKphidelt Firstly I thankyou Now I would like to take your formula pleas to one more stage please. =SUMIF(G1:G104,"Plus",F1:F104) =SUMIF(G1:G104,"Minus",F1:F104) =SUMIF(G1:G104,"Plus","Minus",F1:F104) My objective is to now add Column but the above is not working What do I reqiure to do please to add the column using both "Plus" and "minus" ps I have some rows with "No Change" in Column G1 to G104 Thankyou. "AKphidelt" wrote: Try =SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
See, you make it too complex <vbg
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ragdyer" wrote in message ... So, what you're saying, is that you want to add "Plus" and "Minus" *AND* "No Change" ... all together. You didn't say that at the beginning, did you?<bg -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steved" wrote in message ... I thankyou all. Sum(F1:F104) Did as you all had said, My brain today is very slow today. "AKphidelt" wrote: Not sure we are understanding your request. If G1:G104 has just Plus and Minus then a simple Sum(F1:F104) would work. Like Bob said. "Steved" wrote: Hello AKphidelt Firstly I thankyou Now I would like to take your formula pleas to one more stage please. =SUMIF(G1:G104,"Plus",F1:F104) =SUMIF(G1:G104,"Minus",F1:F104) =SUMIF(G1:G104,"Plus","Minus",F1:F104) My objective is to now add Column but the above is not working What do I reqiure to do please to add the column using both "Plus" and "minus" ps I have some rows with "No Change" in Column G1 to G104 Thankyou. "AKphidelt" wrote: Try =SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
And this is one of the *rare* occasions that I read the *entire* post before
responding!<g -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Bob Phillips" wrote in message ... See, you make it too complex <vbg -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ragdyer" wrote in message ... So, what you're saying, is that you want to add "Plus" and "Minus" *AND* "No Change" ... all together. You didn't say that at the beginning, did you?<bg -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steved" wrote in message ... I thankyou all. Sum(F1:F104) Did as you all had said, My brain today is very slow today. "AKphidelt" wrote: Not sure we are understanding your request. If G1:G104 has just Plus and Minus then a simple Sum(F1:F104) would work. Like Bob said. "Steved" wrote: Hello AKphidelt Firstly I thankyou Now I would like to take your formula pleas to one more stage please. =SUMIF(G1:G104,"Plus",F1:F104) =SUMIF(G1:G104,"Minus",F1:F104) =SUMIF(G1:G104,"Plus","Minus",F1:F104) My objective is to now add Column but the above is not working What do I reqiure to do please to add the column using both "Plus" and "minus" ps I have some rows with "No Change" in Column G1 to G104 Thankyou. "AKphidelt" wrote: Try =SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding time
I can only guess that the No Change items were all zero, otherwise it
couldn't work. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "RagDyeR" wrote in message ... And this is one of the *rare* occasions that I read the *entire* post before responding!<g -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Bob Phillips" wrote in message ... See, you make it too complex <vbg -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ragdyer" wrote in message ... So, what you're saying, is that you want to add "Plus" and "Minus" *AND* "No Change" ... all together. You didn't say that at the beginning, did you?<bg -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steved" wrote in message ... I thankyou all. Sum(F1:F104) Did as you all had said, My brain today is very slow today. "AKphidelt" wrote: Not sure we are understanding your request. If G1:G104 has just Plus and Minus then a simple Sum(F1:F104) would work. Like Bob said. "Steved" wrote: Hello AKphidelt Firstly I thankyou Now I would like to take your formula pleas to one more stage please. =SUMIF(G1:G104,"Plus",F1:F104) =SUMIF(G1:G104,"Minus",F1:F104) =SUMIF(G1:G104,"Plus","Minus",F1:F104) My objective is to now add Column but the above is not working What do I reqiure to do please to add the column using both "Plus" and "minus" ps I have some rows with "No Change" in Column G1 to G104 Thankyou. "AKphidelt" wrote: Try =SUMIF(G1:G104,"Plus",F1:F104) "Steved" wrote: Hello from Steved I have in Column F1 to F104 times that I "SUM" which is ok. Now for my issue and that is some off the time is Plus and some are Minus I have the labels "Plus" and "Minus" in Column G1 to G104. My question please is That I want to add the "Plus" only How do I acheive this please. Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Time | Excel Worksheet Functions | |||
| Adding time [t]:mm:ss | Excel Worksheet Functions | |||
| Time log adding time from separate sheets | New Users to Excel | |||
| Adding time | New Users to Excel | |||
| Adding time to date-time formatted cell | Excel Discussion (Misc queries) | |||
Linear Mode
