View original (French)

Incrementation de 15 minutes par intervalles de 15 minutes

YOULS Posted messages 37 Status Member -  
Mike-31 Posted messages 18205 Registration date   Status Contributor 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 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor 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
  2. Mike-31 Posted messages 18205 Registration date   Status Contributor Last intervention   5 147
     
    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