time and date picker

  1. S

    UX design for times in Excel. How to "scroll" the times ?

    So I am working on user interface on one worksheet and not sure how to make time fields more user friendly. Right now it is just validation list in increment of 5 for minutes and separate field for hours, while I want a user to be able to select any time. E.g 22:47 or 3:21 And I am thinking...
  2. G

    find the connecting flights based on criteria

    Hi all, I have been struggling with the following for a number of days now. I want to be able to retrieve the flights that can be connected with Y flight. Basically.. I have Flight nr AA0001 "Y" and based on a departure and arrival list and the minimum connecting time, i want to see which "X"...
  3. B

    Insert static time stamps into two different cells based on the variable of another cell

    Hello, I would like Excel to insert a time in and a time out into the time in and out columns. When someone arrives we change the 0 to a 1 next to their name and then enter in the time manually to the time in column. When they leave we change 1 back to a 0 and then enter in the time manually to...
  4. E

    adding to a cell in a different row based on what time it is when a button is clicked

    I am trying to make a sub that when run (a button is clicked) it adds one to the value of a particular row based on what time it is. for example, my sheet has an hour in 8 rows column B (based on what shift is using the program the times will differ) When the button is hit It needs to add 1 to...
  5. J

    Date and Time Picker in a range not just a cell...

    Hi I am trying to create a column of date and time pickers 1 for each row. I have learned how to do 1 in a cell but i would like 1 in each row. I can copy and paste them in but it would take forever. Please can anyone help me.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top