Re: Time conversion formula help

Harun24HR sorry I guess I should’ve included an example. Say I have multiple “training times in an excel tracker such as 1:45 = an hour and 45 minutes. I would like the formula to accept 1+45 and add the sum off all different times. So 1:30 twice is 3:00 and I’m just trying to get to a point where I input 1+30 and 1+30= 3 in my sum box. Essentially just replacing the colon with the plus sign. No matter what I do it won’t accept the hour number in front of the + but it accepts the minutes behind the + sign. So if I input 1+00 it won’t register but if I input +45 it accepts the 45 into the formula and shows +45.