Sum Time Ranges
Multi tool use
up vote
1
down vote
favorite
What I'm trying to accomplish is adding together two time ranges to get a total.
The time ranges are each in a single cell, so one cell has, for example, 7:00 - 12:00.
Is there a way to add that to the values of other cells that have various time ranges to get a total for all?
microsoft-excel worksheet-function
edited 2 days ago
zx485
539313
asked 2 days ago
Cassidy Cantrell
62
New contributor
Cassidy Cantrell 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 |
up vote
1
down vote
favorite
What I'm trying to accomplish is adding together two time ranges to get a total.
The time ranges are each in a single cell, so one cell has, for example, 7:00 - 12:00.
Is there a way to add that to the values of other cells that have various time ranges to get a total for all?
microsoft-excel worksheet-function
edited 2 days ago
zx485
539313
asked 2 days ago
Cassidy Cantrell
62
New contributor
Cassidy Cantrell 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 |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
What I'm trying to accomplish is adding together two time ranges to get a total.
The time ranges are each in a single cell, so one cell has, for example, 7:00 - 12:00.
Is there a way to add that to the values of other cells that have various time ranges to get a total for all?
microsoft-excel worksheet-function
edited 2 days ago
zx485
539313
asked 2 days ago
Cassidy Cantrell
62
New contributor
Cassidy Cantrell is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
What I'm trying to accomplish is adding together two time ranges to get a total.
The time ranges are each in a single cell, so one cell has, for example, 7:00 - 12:00.
Is there a way to add that to the values of other cells that have various time ranges to get a total for all?
microsoft-excel worksheet-function
microsoft-excel worksheet-function
edited 2 days ago
zx485
539313
asked 2 days ago
Cassidy Cantrell
62
New contributor
Cassidy Cantrell is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
zx485
539313
asked 2 days ago
Cassidy Cantrell
62
New contributor
Cassidy Cantrell is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
zx485
539313
edited 2 days ago
zx485
539313
edited 2 days ago
zx485
539313
539313
asked 2 days ago
Cassidy Cantrell
62
New contributor
Cassidy Cantrell is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
Cassidy Cantrell
62
asked 2 days ago
Cassidy Cantrell
62
62
New contributor
Cassidy Cantrell is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Cassidy Cantrell is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Cassidy Cantrell 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 |
add a comment |
1 Answer
1
active
oldest
votes
up vote
2
down vote
Here is how to get 5 hours from your text cell 7:00 - 12:00. (If your data is in cell A1.)
=(VALUE(MID(A1,SEARCH("-",A1,1)+1,LEN(A1)-SEARCH("-",A1,1)))-VALUE(MID(A1,1,SEARCH("-",A1,1)-1)))*24
Just set up the adding situation for each of your cells you convert with a similar formula.
edited 2 days ago
zx485
539313
answered 2 days ago
Brian
212
New contributor
Brian 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 |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
Here is how to get 5 hours from your text cell 7:00 - 12:00. (If your data is in cell A1.)
=(VALUE(MID(A1,SEARCH("-",A1,1)+1,LEN(A1)-SEARCH("-",A1,1)))-VALUE(MID(A1,1,SEARCH("-",A1,1)-1)))*24
Just set up the adding situation for each of your cells you convert with a similar formula.
edited 2 days ago
zx485
539313
answered 2 days ago
Brian
212
New contributor
Brian 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 |
up vote
2
down vote
Here is how to get 5 hours from your text cell 7:00 - 12:00. (If your data is in cell A1.)
=(VALUE(MID(A1,SEARCH("-",A1,1)+1,LEN(A1)-SEARCH("-",A1,1)))-VALUE(MID(A1,1,SEARCH("-",A1,1)-1)))*24
Just set up the adding situation for each of your cells you convert with a similar formula.
edited 2 days ago
zx485
539313
answered 2 days ago
Brian
212
New contributor
Brian 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 |
up vote
2
down vote
up vote
2
down vote
Here is how to get 5 hours from your text cell 7:00 - 12:00. (If your data is in cell A1.)
=(VALUE(MID(A1,SEARCH("-",A1,1)+1,LEN(A1)-SEARCH("-",A1,1)))-VALUE(MID(A1,1,SEARCH("-",A1,1)-1)))*24
Just set up the adding situation for each of your cells you convert with a similar formula.
edited 2 days ago
zx485
539313
answered 2 days ago
Brian
212
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Here is how to get 5 hours from your text cell 7:00 - 12:00. (If your data is in cell A1.)
=(VALUE(MID(A1,SEARCH("-",A1,1)+1,LEN(A1)-SEARCH("-",A1,1)))-VALUE(MID(A1,1,SEARCH("-",A1,1)-1)))*24
Just set up the adding situation for each of your cells you convert with a similar formula.
edited 2 days ago
zx485
539313
answered 2 days ago
Brian
212
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
zx485
539313
edited 2 days ago
zx485
539313
edited 2 days ago
zx485
539313
539313
answered 2 days ago
Brian
212
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 2 days ago
Brian
212
answered 2 days ago
Brian
212
212
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Brian 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 |
add a comment |
Cassidy Cantrell is a new contributor. Be nice, and check out our Code of Conduct.
Cassidy Cantrell is a new contributor. Be nice, and check out our Code of Conduct.
Cassidy Cantrell is a new contributor. Be nice, and check out our Code of Conduct.
Cassidy Cantrell 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%2f1375166%2fsum-time-ranges%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
AzgaxnU7F5B2CMlq6g,hrRKUTtcfnAsmSaIISdef0jWdKLWDJbw,kjIhZbMX,a5 sOm9 Fby H0Dg7WxpxxhfV4Asy
