View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Da Daniel Da Daniel is offline
external usenet poster
 
Posts: 2
Default 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