Get Next Event Time Based on a Fixed DateTime, the Current Time and a Time Multiplier

We're trying to get the "Next Reset" column formulas.


First of all, here's the sample:

exceltimequestion.PNG

Current Time: 13:06

Type,Reset Period (in H),Known Reset DateTime,Next Reset
A,8,10/21/2021 11:33,19:33
B,24,10/22/2021 16:15,16:15
C,5,10/23/2021 2:23,


----


Explanation:
Each type has a "Reset Period" and a "Known Reset DateTime".
Based on those and the current datetime, we need to know the hour of the next reset.


For example:
Type A, has a "Reset Period" of 8 hours, and the "Known Reset DateTime" is 10/21/2021 11:33
Since the current time is 13:06, the next reset should be 19:33.

Hope is clear enough.

How do we do it?

I'm assuming you want to know the next time after the current date/time? In D5 I used:

Please Login or Register  to view this content.

(primarily because Excel doesn't like TIME(24,0,0)). I then copied this down - is this any use?

WBD