Forum Discussion
Gaedupe
Dec 03, 2021Copper Contributor
How do I use excel to calculate the difference between two dates
Help me with the formula for calculating the difference in minutes between two dates
rreiser68
Dec 03, 2021Copper Contributor
You can use the DATEDIF function. If your dates are entered in cells A3 and A5 you can use the formula DATEDIF(A3,A5).
- SergeiBaklanDec 03, 2021Diamond Contributor
=DATEDIF(A3,A5,"D") is more complex equivalent of =INT(A5)-INT(A3) if we speak about datetime, and returns difference in days, not in minutes as it was asked.