Find the Time("01:46") Range and write in Specific cells

Help
1

Hi All,

I have a time (“01:46”) and I need to find range it belongs to and write in specific cells. I am getting time from Unix system.

Hour Time
0:00
1:00
2:00
3:00
4:00
5:00
6:00
7:00
8:00
9:00
10:00
11:00
12:00
13:00
14:00
15:00
16:00
17:00
18:00
19:00
20:00
21:00
22:00
23:00

I am getting time from Unix system. If the time is 01.46 then I need to write in specific cells. 01:00 adjacent cells.

Hour Time
0:00
1:00 1:46
2:00
3:00
4:00
5:00
6:00
7:00
8:00
9:00
10:00
11:00
12:00
13:00
14:00
15:00
16:00
17:00
18:00
19:00
20:00
21:00
22:00
23:00

can any body help me here.

2

Hi Ashwin,
1.firstly take a Excel with 23 rows and 2 columns as Hour and Time.
…Get the time into a variable_Time1 and split it with " : " and take the save the hour …value in saperate vairate as variable_Time2
…Now take a Excel appliction scope in that take a for each activity and check the …variable_Time2 is matched with any of the row in excel , if matched the write the …complete time vaiable_Time1 in that respective row as [row(1)=vaiable_Time.tostring].
and do the same for any input time

3

thank you will try the option.