Hi friends,

I am looking for a function in Excel VBA to return current time (system time) into a specific cell but the return cell should be in higher rounding off multiple of 5 minutes.

E.g

If current time is 16:04:14 then I need return of 16:05:00
If current time is 12:12:06 then I need return of 12:15:00
If current time is 09:57:59 then I need return of 10:00:00

TIA

Regards