Finding and displaying start and end time of a cycle

Hi
I'm doing data analysis for a battery. I need to count the number of charging/discharging/idle cycles and also find the corresponding timestamp when a charging/discharging/idle cycle begins and ends.

Using help from the forum I was able to find the number of cycles.

DC --> Discharging (current<0)
I --> Idle (current=0)
C --> Charging (current>0)

For example:
From time 00:05 to 00:13, the current value is positive, which means battery is charging. So I need to display:
charging_cycle_1_start = 00:05
cycle_charging_1_end = 00:13

Similarly next charging cycle is from 00:41 to 01:00. So I need to show:
charging_cycle_2_start = 00:41
cycle_charging_2_end = 01:00

cycle count test file.xlsx

I'm trying to solve this in excel first but my end goal is to write a python code. I was hoping to solve in excel to understand the basic idea of how it will work.

Please help.
Regards

Thanks.
When I opened your file it showed me some values but when I clicked on enable editing I got error on the formula. I tried CTRL+SHIFT+ENTER as well but still got the error.
Is there something I need to enable for this formula to work?

This something that I tried yesterday. Very basic logic but I was able to get cycle start and end time. But this won't do it for me. Your formula is what I need.

cycle count test file_1.xlsx

Regards