How to sum hh:mm:ss with specific data in another column?How to sum a set of data in Excel?Find column where...
Is a debit card dangerous for an account with low balance and no overdraft protection?
Checking for the existence of multiple directories
What makes the Forgotten Realms "forgotten"?
Why zero tolerance on nudity in space?
Why does a metal block make a shrill sound but not a wooden block upon hammering?
Word or phrase for showing great skill at something without formal training in it
Why do neural networks need so many training examples to perform?
How to avoid being sexist when trying to employ someone to function in a very sexist environment?
What is this metal M-shaped device for?
Every character has a name - does this lead to too many named characters?
Avoiding morning and evening handshakes
Pre-1980's science fiction short story: alien disguised as a woman shot by a gangster, has tentacles coming out of her breasts when remaking her body
Can you earn endless XP using a Flameskull and its self-revival feature?
Lick explanation
Isn't using the Extrusion Multiplier like cheating?
Quenching swords in dragon blood; why?
It took me a lot of time to make this, pls like. (YouTube Comments #1)
Why are the books in the Game of Thrones citadel library shelved spine inwards?
Broken patches on a road
Placing an adverb between a verb and an object?
A minimum of two personnel "are" or "is"?
How to prevent users from executing commands through browser URL
Is it a fallacy if someone claims they need an explanation for every word of your argument to the point where they don't understand common terms?
Why would the Pakistan airspace closure cancel flights not headed to Pakistan itself?
How to sum hh:mm:ss with specific data in another column?
How to sum a set of data in Excel?Find column where sum is meeting condition?How to sum rows with a timepoint and a duration criteriaExcel Join tables with calculation over a third columnFunction to sum numbers in ExcelHow to sum only values in one column that have a unique value in another column?MS Excel 2016 - Search a ID in Column A and compare corresponding Values in Column B and get condition based result in Column CHow to sum a column with cells containing text?Excel: Sum up a column based on conditionsSum rows based on criteria in columns
I want to get the duration but with the active column condition = yes.
I already try with SUMIF function but the result was 00:00:00.
microsoft-excel
edited 4 mins ago
Twisty Impersonator
18.5k146699
asked 1 hour ago
user10883017user10883017
1
New contributor
user10883017 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I want to get the duration but with the active column condition = yes.
I already try with SUMIF function but the result was 00:00:00.
microsoft-excel
edited 4 mins ago
Twisty Impersonator
18.5k146699
asked 1 hour ago
user10883017user10883017
1
New contributor
user10883017 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Welcome to SuperUser! If you have tried something withSUMIFthen post that. Please review site guidelines on How to Ask and Minimal, Complete, and Verifiable example and then edit your post instead of adding information in a comment.
– Rey Juna
36 mins ago
add a comment |
I want to get the duration but with the active column condition = yes.
I already try with SUMIF function but the result was 00:00:00.
microsoft-excel
edited 4 mins ago
Twisty Impersonator
18.5k146699
asked 1 hour ago
user10883017user10883017
1
New contributor
user10883017 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I want to get the duration but with the active column condition = yes.
I already try with SUMIF function but the result was 00:00:00.
microsoft-excel
microsoft-excel
edited 4 mins ago
Twisty Impersonator
18.5k146699
asked 1 hour ago
user10883017user10883017
1
New contributor
user10883017 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 4 mins ago
Twisty Impersonator
18.5k146699
asked 1 hour ago
user10883017user10883017
1
New contributor
user10883017 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 4 mins ago
Twisty Impersonator
18.5k146699
edited 4 mins ago
Twisty Impersonator
18.5k146699
edited 4 mins ago
Twisty Impersonator
18.5k146699
18.5k146699
asked 1 hour ago
user10883017user10883017
1
New contributor
user10883017 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 1 hour ago
user10883017user10883017
1
asked 1 hour ago
user10883017user10883017
1
1
New contributor
user10883017 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
user10883017 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
user10883017 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Welcome to SuperUser! If you have tried something withSUMIFthen post that. Please review site guidelines on How to Ask and Minimal, Complete, and Verifiable example and then edit your post instead of adding information in a comment.
– Rey Juna
36 mins ago
add a comment |
1
Welcome to SuperUser! If you have tried something withSUMIFthen post that. Please review site guidelines on How to Ask and Minimal, Complete, and Verifiable example and then edit your post instead of adding information in a comment.
– Rey Juna
36 mins ago
1
1
Welcome to SuperUser! If you have tried something with
SUMIF then post that. Please review site guidelines on How to Ask and Minimal, Complete, and Verifiable example and then edit your post instead of adding information in a comment.– Rey Juna
36 mins ago
Welcome to SuperUser! If you have tried something with
SUMIF then post that. Please review site guidelines on How to Ask and Minimal, Complete, and Verifiable example and then edit your post instead of adding information in a comment.– Rey Juna
36 mins ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
user10883017 is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1410643%2fhow-to-sum-hhmmss-with-specific-data-in-another-column%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
user10883017 is a new contributor. Be nice, and check out our Code of Conduct.
user10883017 is a new contributor. Be nice, and check out our Code of Conduct.
user10883017 is a new contributor. Be nice, and check out our Code of Conduct.
user10883017 is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1410643%2fhow-to-sum-hhmmss-with-specific-data-in-another-column%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Welcome to SuperUser! If you have tried something with
SUMIFthen post that. Please review site guidelines on How to Ask and Minimal, Complete, and Verifiable example and then edit your post instead of adding information in a comment.– Rey Juna
36 mins ago