| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calc minutes and seconds difference | Excel Worksheet Functions | |||
| Difference of time in hours or minutes | Excel Discussion (Misc queries) | |||
| Display minutes ONLY and calc difference | Excel Discussion (Misc queries) | |||
| Calculating time difference in minutes | Excel Worksheet Functions | |||
| Difference of date & time in minutes | Excel Worksheet Functions | |||
Linear Mode
