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