| 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
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. |
|
#9
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. |
|
#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. |
| 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) | |||
Hybrid Mode
