How to subtract two date and time fieds in excel [duplicate]
This question already has an answer here:
subtract datetime in excel
2 answers
I have two fields having date and time like: 11/08/2018 12:04 and 11/8/2018 12:00. I want Excel to subtract these fields and return me a new field with the difference(which in this case is 4mins)
excel
asked Nov 21 '18 at 11:08
Sammy SinghSammy Singh
12
marked as duplicate by Ron Rosenfeld, greg-449, Rob, Mark Rotteveel, Max Vollmer Nov 21 '18 at 15:43
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |
This question already has an answer here:
subtract datetime in excel
2 answers
I have two fields having date and time like: 11/08/2018 12:04 and 11/8/2018 12:00. I want Excel to subtract these fields and return me a new field with the difference(which in this case is 4mins)
excel
asked Nov 21 '18 at 11:08
Sammy SinghSammy Singh
12
marked as duplicate by Ron Rosenfeld, greg-449, Rob, Mark Rotteveel, Max Vollmer Nov 21 '18 at 15:43
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
2
What have you researched / tried so far, and what problem / error did you experience?
– Olly
Nov 21 '18 at 11:20
add a comment |
This question already has an answer here:
subtract datetime in excel
2 answers
I have two fields having date and time like: 11/08/2018 12:04 and 11/8/2018 12:00. I want Excel to subtract these fields and return me a new field with the difference(which in this case is 4mins)
excel
asked Nov 21 '18 at 11:08
Sammy SinghSammy Singh
12
This question already has an answer here:
subtract datetime in excel
2 answers
I have two fields having date and time like: 11/08/2018 12:04 and 11/8/2018 12:00. I want Excel to subtract these fields and return me a new field with the difference(which in this case is 4mins)
This question already has an answer here:
subtract datetime in excel
2 answers
excel
excel
asked Nov 21 '18 at 11:08
Sammy SinghSammy Singh
12
asked Nov 21 '18 at 11:08
Sammy SinghSammy Singh
12
asked Nov 21 '18 at 11:08
Sammy SinghSammy Singh
12
asked Nov 21 '18 at 11:08
Sammy SinghSammy Singh
12
asked Nov 21 '18 at 11:08
Sammy SinghSammy Singh
12
12
marked as duplicate by Ron Rosenfeld, greg-449, Rob, Mark Rotteveel, Max Vollmer Nov 21 '18 at 15:43
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
marked as duplicate by Ron Rosenfeld, greg-449, Rob, Mark Rotteveel, Max Vollmer Nov 21 '18 at 15:43
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
2
What have you researched / tried so far, and what problem / error did you experience?
– Olly
Nov 21 '18 at 11:20
add a comment |
2
What have you researched / tried so far, and what problem / error did you experience?
– Olly
Nov 21 '18 at 11:20
2
2
What have you researched / tried so far, and what problem / error did you experience?
– Olly
Nov 21 '18 at 11:20
What have you researched / tried so far, and what problem / error did you experience?
– Olly
Nov 21 '18 at 11:20
add a comment |
1 Answer
1
active
oldest
votes
TEXT function can used to calculate time.
Assuming the date values are in A1 and A2
=TEXT(A1-A2,"h:mm:ss")
answered Nov 21 '18 at 11:26
Abhilash VishwakarmaAbhilash Vishwakarma
11
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
TEXT function can used to calculate time.
Assuming the date values are in A1 and A2
=TEXT(A1-A2,"h:mm:ss")
answered Nov 21 '18 at 11:26
Abhilash VishwakarmaAbhilash Vishwakarma
11
add a comment |
TEXT function can used to calculate time.
Assuming the date values are in A1 and A2
=TEXT(A1-A2,"h:mm:ss")
answered Nov 21 '18 at 11:26
Abhilash VishwakarmaAbhilash Vishwakarma
11
add a comment |
TEXT function can used to calculate time.
Assuming the date values are in A1 and A2
=TEXT(A1-A2,"h:mm:ss")
answered Nov 21 '18 at 11:26
Abhilash VishwakarmaAbhilash Vishwakarma
11
TEXT function can used to calculate time.
Assuming the date values are in A1 and A2
=TEXT(A1-A2,"h:mm:ss")
answered Nov 21 '18 at 11:26
Abhilash VishwakarmaAbhilash Vishwakarma
11
answered Nov 21 '18 at 11:26
Abhilash VishwakarmaAbhilash Vishwakarma
11
answered Nov 21 '18 at 11:26
Abhilash VishwakarmaAbhilash Vishwakarma
11
answered Nov 21 '18 at 11:26
Abhilash VishwakarmaAbhilash Vishwakarma
11
11
add a comment |
add a comment |
2
What have you researched / tried so far, and what problem / error did you experience?
– Olly
Nov 21 '18 at 11:20