how would i subtract 20 min from the now() function value. my format is m/d/y/ h:m thanks
B bob Jul 8, 2003 #1 how would i subtract 20 min from the now() function value. my format is m/d/y/ h:m thanks
C Chip Pearson Jul 8, 2003 #2 Bob, Try something like =NOW()-TIME(0,20,0) or, faster but less obvious, =NOW()-0.0138888889 Format the cell as desired. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com [email protected]
Bob, Try something like =NOW()-TIME(0,20,0) or, faster but less obvious, =NOW()-0.0138888889 Format the cell as desired. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com [email protected]
