Data in cell A1:B2
| A | B | ||
|---|---|---|---|
| 1 | End Date/Time | 05/11/2003 15:33 | <– =NOW() |
| 2 | Start Date/Time | 10/01/2002 9:33 | <– =NOW()-222.25 |
Formula in cell E2: =(B1-B2)*1440 ( 24 hours*60 minutes=1440 )
Format in cell E2: regular number format
Result: 320,040 minutes
Screenshot // Calculate number of minutes between dates – time in Microsoft Excel
I found it quiet interesting and useful in my day to day office life. Thanks to you and your precious information