View original (French)

Quick timesheet entry in Excel

Solved
touroul Posted messages 526 Registration date   Status Member Last intervention   -  
touroul Posted messages 526 Registration date   Status Member Last intervention   -
Hello the forum!

I’m looking for a simple and effective way to enter time like 8:19 into Excel cells, using the mouse.

I had in mind 3 clicks:

- first click: select a cell formatted as time
- second click: select the full hour (8) from a combobox-like table (0 to 24)
- third click: select the minutes from a combobox-like table (00 to 59)

Have you already found on this forum something similar to this?

Thanks in advance for your help!

6 answers

  1. eugene
     
    I don’t see what’s simpler than typing 8:19…
    0
    1. touroul Posted messages 526 Registration date   Status Member Last intervention   17
       

      I see :)

      0
  2. Raymond PENTIER Posted messages 58226 Registration date   Status Contributor Last intervention   17 490
     

    Hello touroul.

    I completely agree with Eugene:

    With your project, for your second click you will have to choose among 24 values, and for your third click you will have to search through 60 values!

    It will never be as fast as typing =8:19 or =23:55

    Think carefully...

    Best regards

    Indeed, retirement is good! Especially in the Caribbean...
    Raymond (INSA, AFPA)

    0
  4. touroul Posted messages 526 Registration date   Status Member Last intervention   17
     
    < p>Good evening Daniel

    Thanks for this proposal, it’s already not bad.

    I was picturing ComboBox-type tables with all possible responses; it’s close to that.

    Some think it’s futile, but try typing a time on a tablet PC: you have to bring up the keyboard and enter the time on a tiny keyboard without making mistakes.

    Could someone know how to replace the dropdown lists in Danielc’s file with multi-column comboboxes?

    Thanks

    0
  6. danielc0 Posted messages 2211 Registration date   Status Member Last intervention   294
     
    Hello,

    Test (you must choose the hour before the minutes):

    https://www.swisstransfer.com/d/15b52462-30b1-4ba3-9afb-94bd46c9c6fd

    Daniel
    0
    1. touroul Posted messages 526 Registration date   Status Member Last intervention   17
       

      Thanks Daniel

      I had also come up with something similar, I used that as a base, but I wanted to avoid vertical scrolling.

      It might be useful for something else perhaps. Thanks again

      1
      1. danielc0 Posted messages 2211 Registration date   Status Member Last intervention   294 > touroul Posted messages 526 Registration date   Status Member Last intervention  
         

        There is no scrolling.

        0
  7. touroul Posted messages 526 Registration date   Status Member Last intervention   17
     

    Well...
    In the end, with AI and a few manual tweaks, I managed it. This is really what I wanted:

    https://uploadnow.io/f/Fp2JVf2

    If it can help someone ...

    Thank you

    0
    1. danielc0 Posted messages 2211 Registration date   Status Member Last intervention   294
       

      a modification to make :

      0
      1. touroul Posted messages 526 Registration date   Status Member Last intervention   17 > danielc0 Posted messages 2211 Registration date   Status Member Last intervention  
         

        Okay, thanks, I'll take a look at that.

        0