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!