One cell and formula

[kuzna26]

Hey guys ,

Please I’m working a spreadsheet but I have question
There are 3 columns
A1:A10 - Estimated Departure Time
B1:B10 - Delay in minutes regarding to Estimated Departure time

I want to input time in A1, but if there is a delay I will input the delay time in B1 and it should automatically add up with time in A1


Thanks

[Pete_UK]

Try this in C1:

=A1 + B1/24/60

Format C1 as a time (or use the Format Painter to copy the format from A1 into C1), and then copy down.

Hope this helps.

Pete