I'm creating a multi-day agenda that keeps changing so I want to add the number of minutes to the start time to calculate the end time and next starting time.

column a column b column c
7:30 AM 7:45 AM 15
7:45 AM 8:00 AM 15
8:00 AM 8:30 AM 30
8:30 AM 9:00 AM 30

how do i format column c so that its recognized as minutes?

and what is the formula for cell b2 to add a2 and c2?

thanks in advance for any help you can provide!

nan