Posted to microsoft.public.excel.programming
|
|
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
|