Travis
Active member
Ok guys,I'm asking here as I am HOPELESS with all the technical stuff. I am after some help with creating an excel Formula to speed up a process that I do in generating overnight schedule for a community tv station. Here's an example of how the document is set up:
Column B(Blue) features the program starting time. Column C (Green) features the programs end time and Column D(Red) Features the program running time. What I do currently is take the program start time(B) and manually work out the finish time i.e Program A starts at 01:00 and runs for 24 minutes. Therefore,the finishing time is 01:24.
What I want to know is:
A) Is there a formula I can use that will take the program start time and add the program running time to it,to generate the finishing time?
B) If there is a formula for A, Is there a way to get the result in hours (i.e Program A starts at 01:00 and goes for 94 minutes. would there be a way for the above formula to tell me the finishing time exactly,instead of just telling me 01:94?)
Is there a way? or am I just dreaming?
Any Help would be greatly appreciated!
P.S Sorry about the really long post!
Column B(Blue) features the program starting time. Column C (Green) features the programs end time and Column D(Red) Features the program running time. What I do currently is take the program start time(B) and manually work out the finish time i.e Program A starts at 01:00 and runs for 24 minutes. Therefore,the finishing time is 01:24.
What I want to know is:
A) Is there a formula I can use that will take the program start time and add the program running time to it,to generate the finishing time?
B) If there is a formula for A, Is there a way to get the result in hours (i.e Program A starts at 01:00 and goes for 94 minutes. would there be a way for the above formula to tell me the finishing time exactly,instead of just telling me 01:94?)
Is there a way? or am I just dreaming?
Any Help would be greatly appreciated!
P.S Sorry about the really long post!