it would be much easier if you could split the times into 2 cells

Of course, but that would be the as much work as not using a formula

I've gotten it theory but it gives the result in decimal format, not as H:MM PM

In cell L13 I have 6:55 - 7:00 PM, and I managed to make this formula

`=CONCAT(LEFT(L13, SEARCH(" ",L13,1))+TIME(0,5,0)," - ", RIGHT(L13, SEARCH(" ",L13,1)+2)+TIME(0,5,0))`

which essentially finds the 2 times, adds 5 to each and then joins them with the "-" but the result is in decimal format like this: 0.291666666666667 - 0.795138888888889 even after I change the cell type to time it has no affect