I would like to do some math on current time:
I would like to have a cell which calculate current time is over a 15-minutes interval.
e.g.
(1) If current time is 4:05, it is 5 minutes pass 4:00. The cell shows 5
(2) If current time is 4:12, it is 12 minutes pass 4:00. The cell shows 12
(3) If current time is 7:23, it is 8 minutes pass 7:15. The cell shows 8
(4) If current time is 5:59, it is 14 minutes pass 5:45. The cell shows 14
(5) If current time is 6:33, it is 3 minutes pass 6:30. The cell shows 3
Bookmarks