Hi,
I have date and time data in column A. I want that date and time from 1/14/2022 0:00 to 1/14/2022 0:04 (from cell A2 to A926) should be written as 0 in column B.
Let me explain this,
1/14/2022 0:00 starts from cell A2 and
1/14/2022 0:04 ends at Cell A926
I want that for all these timestamps only this 0 should be written in the column B
in the same way
1/14/2022 0:05 starts from cell A927 and
1/14/2022 0:09 ends at Cell A1602
I want that for all these timestamps only this 1 should be written in the column B
and so on
in short, for all timestamps starting from 00:00 to 04:59 minutes should be written as 0
for all timestamps starting from 00:05 to 09:59 minutes should be written as 1
and so on
(Sample file is attached for further clarification)
Bookmarks