What formula is used to add or subtract minutes from a time in a .
I am trying to develop a bus timetable in a spreadsheet. I have the section
times for each section and wish to add minutes to the start time. i.e. 7.00am leave stop 1 plus 6 minutes = stop 2 time. Stop 2 plus 14 minutes = stop 3 time. Is there a formula that does this and show result as hh:mm? |
One way:
A1: 7:00 A2: =A1+TIME(0,6,0) Format A2 as a time, if necessary. Another (since XL stores times as fractional days, so 1 minute = 1/(24*60) = 1/1440): A2: =A1 + 6/1440 And another: A2: =A1+"0:06" In article , "Lucky Phil" <Lucky wrote: I am trying to develop a bus timetable in a spreadsheet. I have the section times for each section and wish to add minutes to the start time. i.e. 7.00am leave stop 1 plus 6 minutes = stop 2 time. Stop 2 plus 14 minutes = stop 3 time. Is there a formula that does this and show result as hh:mm? |
All times are GMT +1. The time now is 07:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com