How to use the DATEDIFF Function (VBA)
You can use the VBA function Datediff and it will determine the elapsed seconds.
https://www.techonthenet.com/excel/f...s/datediff.php
https://stackoverflow.com/questions/46754917/how-to-calculate-time-difference-in-second-in-excel-vba-for-different-group-of
Obtained from the OzGrid Help Forum.
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 Compute a Date Difference in an IF statement |
| How to create a formula for multi criteria lookup with dates |
| Insert time/date with click on cell but never update |
| How to retain previous date function |
| How to use the =TODAY() for start up but freeze that date |
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
