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...

__________________
Using O365 v2503 - 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]