Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtract time from now()
how would i subtract 20 min from the now() function value.
my format is m/d/y/ h:m thanks |
#2
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtract Time | New Users to Excel | |||
Subtract hours from a time and get the correct time | Excel Worksheet Functions | |||
how to increment time & subtract time? | Excel Worksheet Functions | |||
Add, subtract time | Excel Worksheet Functions | |||
how do I add/subtract time when I'm going from PM to AM (ex. 11:4. | Excel Worksheet Functions |