Subtract 1 min from Date

[yogeshmaney]

Hi
My Data is in "dd/mm/yy hh:mm" format. I want to subtract 1 min from it. How do I do it in VBA.

Yogi

 

[VoG]

Try like this

d = d - TimeSerial(0, 1, 0)

 

[Sektor]

[COLOR="Blue"]Sub[/COLOR] MinusMinute()

    [COLOR="Blue"]With[/COLOR] ActiveCell
        .Value = DateAdd("n", -1, .Value)
    [COLOR="Blue"]End[/COLOR] [COLOR="Blue"]With[/COLOR]

[COLOR="Blue"]End[/COLOR] [COLOR="Blue"]Sub[/COLOR]

 

[yogeshmaney]

Great !