Hi,

I have an excel column that is in general form with time ranges (IE. 8:30AM-12:30PM, 9:15AM-11:15AM)
I need a separate column that has this time range with a 15minute sooner start time but same end time (IE. 8:30AM-12:30PM is reported as 8:15AM-12:30PM).
Is there a formula that can pull this in without me adding extra columns or forcing manual adjustments? I can trim out 8:30 but seem to get stuck subtracting 15minutes and adding back the end time. I have almost 200 time range combinations to adjust...

Any help would be appreciated. thank you!