Good Evening



I am trying to generate times for an agenda.

Each of the 52 groups the agenda relates to has a different start time.

So I enter start time in cell A2

10 minutes later everyone needs to introduce themselves so I need a formula for cell B2 that will take the value of cell A2 (formatted hh:mm) and add 00:10 to it and output the resulting value

15 minutes later score cards are handed out so I need C2 to be B2+00:15

and so on.

how do i do this on windows 10 in excel 2016?

To Excel a day =1, an hour = 1/24, etc..
So to add 10 minutes add 1/(24*6)? The same reasoning for 15 minutes, etc...

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

A2 is start time
B2=A2+TIME(0,10,0)
C2=B2+TIME(0,15,0) and so on
Format affected cells as [h]:00

Given there are 1440 minutes in a day, the simplest solution is to add n/1440 to the value, where n is the number of minutes. For example:
=A1+10/1440
=A1+15/1440
where the base time is in A1.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]