Skip to main content
3 of 3
edited body
pnuts
  • 17.8k
  • 5
  • 54
  • 103

UNTESTED (because for example the Nairobi Stock Exchange is closed at present) but

& year(now()) & month(now()) & day(now()) & hour(now()) & MINUTE(),  

to

& A1,

with =int(minute(now())/5) in A1 may be worth trying.

pnuts
  • 17.8k
  • 5
  • 54
  • 103