Adding minutes to a time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add times? 2
Having Blank Cells, etc. ? 1
hard slope question 2
arrived in appt time 1
Adding minutes to hours/minutes 4
Time calculating problem 2
Time, & Ceiling? 3
minutes 2

Back
Top