View original (French)

Automatic date (morning - afternoon)

Solved
cocoviet Posted messages 2 Registration date   Status Member Last intervention   -  
Pitu Posted messages 1460 Status Contributor -
Bonjour,

I would like Excel to note in a cell based on the time whether it is morning or afternoon.

If this is possible, thank you for your help!

Configuration: Windows 7 / Firefox 10.0

3 answers

  1.
    Pitu Posted messages 1460 Status Contributor 125
     
    Hello,

    =IF(HOUR(NOW())<=11;"MORNING";"AFTERNOON")

    This will display MORNING until 11:59:59 ...

    --

      (:*Þ   Pitù 
    Well, neither by any means, nor even quasi modo
    1
    1. cocoviet Posted messages 2 Registration date   Status Member Last intervention  
       
      Thank you very much!
      0
  2. asco3 Posted messages 133 Status Member 29
     
    Good evening,

    I've tried but I can't do it...
    0
  3. Pitu Posted messages 1460 Status Contributor 125
     
    Hello,

    An example in the workbook there ---> https://www.cjoint.com/?BCfj4XxhBJP

    --

      (:*Þ   Pitù 
    Oh well, not even close
    0
    1. asco3 Posted messages 133 Status Member 29
       
      Good evening,
      I must say that personally I work in shifts, meaning 5am-1pm / 1pm-9pm / 9pm-5am.
      Perhaps we should evolve the formula?

      Thank you for your help...
      0
    2. Pitu Posted messages 1460 Status Contributor 125
       
      Hello,
      Tell me exactly what you would like, I don't quite understand.
      0
    3. asco3 Posted messages 133 Status Member 29
       
      Hello Pitu,

      I work in shifts, meaning: morning 5am - 1pm; afternoon 1pm - 9pm; night 9pm - 5am
      I fill out a shift log sheet.
      When I'm on the morning shift for example, I would like that according to the current time, it automatically fills in the box where I manually enter the information.

      I tried this:
      =IF(HOUR(NOW())<=4,"night",IF(HOUR(NOW())<=12,"morning",IF(HOUR(NOW())<=20,"afternoon")))

      And it works!
      Thank you...
      1
    4. Pitu Posted messages 1460 Status Contributor 125
       
      Well, in this case, the expression "You're welcome" makes perfect sense ... ;o)
      0