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

More Under Finance

Posted Under

Category : Finance (3456)
Type : Articles (14344)
Tags : Excel Tips (35)

0 responses to “Excel Tips – How to Calculate number of minutes between dates – time in Microsoft Excel”

  1. Natwar says:

    I found it quiet interesting and useful in my day to day office life. Thanks to you and your precious information

Leave a Reply

Your email address will not be published. Required fields are marked *