Time calculations

[Steve18vtx]

I am new to using excel and need to do a time calculation. I work for an airline and need to calculate flight arrival times. Flight sectors are always calculated in minutes, i need to enter a departure time in one cell then add the sector length to give an estimated arrival time i.e 23:00 + 70mins = 00:10

Any help with this will be greatly appreciated

[Dav]

if the time is entered as 23:00 it is stored as a number 0.5 being midday, 0.75 being 6pm etc

if you have the departure time in A1, the sector length in B1 as 70 and the arrival time in C1 in c1 put a1+b1/60/24 and format as time hh:mm

Regards

Dav

[Steve18vtx]

Hi Dav, thanks for your help