View original (French)

Incrementation de 15 minutes par intervalles de 15 minutes

YOULS Posted messages 37 Status Membre -  
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   -
Hello,
how can I copy a cell from the right in date format: hh:mm, that increments by 15 minutes?
Thank you

Configuration: Windows 7 / Mozilla 11.0

2 réponses

Réponse 1 / 2
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
Hello
Right cell? Is it political?
that said:
enter the 1st hour in the 1st cell
in the next cell, enter the time increased by 15 minutes
select both cells and drag to the right or left, or down according to your preferences.
Or also
in the second cell, if the first is A1:
=A1+"00:15"
to drag likewise

best regards

--
To err is human, to persevere is diabolical
5
Réponse 2 / 2
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 145
 
Hello,

either directly, in A1 for example enter 9:00, in B1 enter 9:15 select both cells, left click on the small square at the bottom right of the selection and without letting go, increment to the right

A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.
0