I need to create a variable that subtracts one hour from another, let me explain:
Event time A: 12:30
Event time B: 12:00
Time between event A and event B = 00:30
What I need is the formula that gives me the time between events.
I have created formulas that give me the time of the events but when trying to subtract one from another it does not leave me giving me an invalid data type error.