Calculate number of minutes between dates – time in Microsoft Excel
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
Related posts:
- Calculate Years, Months, Days elapsed
- One Number That Will Ring All Your Phones
- Combining Text and Values in one cell
- Useful Tips in Excel
- How to Activate Chinese Mobile IMEI Number Online
- Moving Between Precedent and Dependent Cells
- Get International Phone Number With FAX, Voicemail
- Power of CTRL key in Excel
- Google Adsense Program to calculate earnings has a Bug.
- Update Charts Automatically
|
|
Follow us on Twitter
Bookmark on del.icio.us
Become a Fan of Facebook
Add to Google Reader
Comments on this entry are closed.