Adding minutes to a time

S

sacredarms

I have a spreadsheet with three columns.

Column A = time Column B = ETA Column C = Arrival time
3:24 :15 3:39Pm

I am having dificulty getting the answer in column C.
Any help greatly appreciated.
Thanks
 
B

Biff

Hi!

=A1+B1

Column B time has to be entered as a time - 00:15

Or, you could just enter the integer, 15 and use this
formula to get the same result:

=A1+B1/1440

Biff
 
Top