ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Date Difference in ONLY minutes (https://www.excelbanter.com/excel-discussion-misc-queries/143428-date-difference-only-minutes.html)

[email protected]

Date Difference in ONLY minutes
 
I am trying to determine the total difference in minutes between a
date in a cell and NOW(). For example,

F3 = an older date/time, ex. 5/18/2007 18:14

I'd like to know how many minutes have transpired up until the current
date/time.

Any help would be great!


Chip Pearson

Date Difference in ONLY minutes
 
If you have your date-time in A1, use

=(NOW()-A1)*60*24


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)


wrote in message
ups.com...
I am trying to determine the total difference in minutes between a
date in a cell and NOW(). For example,

F3 = an older date/time, ex. 5/18/2007 18:14

I'd like to know how many minutes have transpired up until the current
date/time.

Any help would be great!





All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com