How to calculate duration difference between two dates
Requirement:
The user would like to calculate date difference between Reported Date and Actual Finish.
Example: In the Duration Field output should be like
0 Day, 4 Hours, 0 Second
Solution:
This formula should work :
Code:
=DATEDIF(E2,F2,"d")&" day(s), "&MOD(HOUR(H2),24)&" hour(s), "&MINUTE(H2)&" minute(s) "&SECOND(H2)&" Second(s)"
Obtained from the OzGrid Help Forum.
Solution provided by nyatiaju.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to convert US to UK dates |
| How to use SUMPRODUCT with dates |
| How to average time between dates |
| How to set dynamic dates for pivot table grouping |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
