| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours and minutes in a column | Excel Discussion (Misc queries) | |||
| Adding hours/minutes to Date/Times | Excel Worksheet Functions | |||
| how do i count how many times x in column a = 1 or 2 in column b | Excel Worksheet Functions | |||
| Adding minutes to Times | Excel Worksheet Functions | |||
| add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
Linear Mode
