| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Now() minus ten minutes
Hello-
I am trying to get the current time less ten minutes to calculate in a cell. I need the time only, no date so I was told to use the MOD portion in the formula below. ActiveCell.FormulaR1C1 = "=MOD(NOW()- Timeserial(0,10,0)" If it is 5:37 AM, I want 5:27 AM reported with now date in the field. Thanks Scott |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: date field minus minutes equals new date | Excel Worksheet Functions | |||
| Minus time | Excel Discussion (Misc queries) | |||
| Minus time | Excel Discussion (Misc queries) | |||
| Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
| How do you subtract time? (ie 03:15 am minus 5 minutes) | Excel Discussion (Misc queries) | |||
Threaded Mode
