subtract time from now()
 

how would i subtract 20 min from the now() function value.
my format is m/d/y/ h:m

thanks

subtract time from now()
 

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




"bob" wrote in message
a...
how would i subtract 20 min from the now() function value.
my format is m/d/y/ h:m

thanks