Adding minutes in second column to times in first column
 

I have a bus schedule which I have entered manually for one departure point
in Column A. The cell are formatted for time (third from the top under the
Time listings).

I know that the arrival will be 6 minutes later which I want to show in
Column B.

For the life of me, I cannot find out or figure out what the formula for
that would be.

Any and all ideas and suggestions would be tremendously appreciated -- thank
you very much!

Daniel

Adding minutes in second column to times in first column
 

=A3+(6/1440)

format as time

or

=A3+TIME(,6,)



--
Regards,

Peo Sjoblom


"Da Daniel" wrote in message
...
I have a bus schedule which I have entered manually for one departure point
in Column A. The cell are formatted for time (third from the top under
the
Time listings).

I know that the arrival will be 6 minutes later which I want to show in
Column B.

For the life of me, I cannot find out or figure out what the formula for
that would be.

Any and all ideas and suggestions would be tremendously appreciated --
thank
you very much!

Daniel

Adding minutes in second column to times in first column
 

THANK YOU SO MUCH!

This would have taken me at least three centuries to figure this out out by
myself!


"Peo Sjoblom" wrote:

=A3+(6/1440)

format as time

or

=A3+TIME(,6,)



--
Regards,

Peo Sjoblom


"Da Daniel" wrote in message
...
I have a bus schedule which I have entered manually for one departure point
in Column A. The cell are formatted for time (third from the top under
the
Time listings).

I know that the arrival will be 6 minutes later which I want to show in
Column B.

For the life of me, I cannot find out or figure out what the formula for
that would be.

Any and all ideas and suggestions would be tremendously appreciated --
thank
you very much!

Daniel