Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I subtract 1 minute from now() ?
HI
=timestamp(now()-1/1440)
Hope it helps
Try this
vNo = 1; //Number of minutes or hours
=TimeStamp(now() - $(vNo)/(24*60)) for minutes
=TimeStamp(now() - $(vNo)/24) for hours