Popup Clock add-in: a straightforward time picker with easy time formatting

Same as entering dates in Excel cells, entering time can be quite frustrating. Should you use AM/PM or a 24-hour format? Do you need just hours and minutes, or seconds as well? Will Excel display time values exactly as you want? With this Excel time picker, you can easily manage appointments and timesheets or add a timestamp on a report.

The Popup Clock add-in is a simple and straightforward time picker:

  • Pops up next to a cell
  • Easy to use: selects cells – set time, or date and time
  • Populates cells, columns, rows or any ranges with time values
  • Choose from numerous default time format options, preset and custom
  • Works both in 64 bit and 32 bit Excel

 

Add "Popup Clock" to Excel 2016, 2013, 2010, 2007

Works in: Microsoft Excel 2016 – 2007, desktop Office 365 (both 32 bit and 64 bit).

Download XLTools Add-in

Popup Clock ribbon button

 

Learn your way around:

Note: UNDO (undo the last operation) is not applicable. We recommend that you save backup copies of your files or use XLTools Version Control to keep track of changes.

 

How to insert or change time in a cell using the Popup Clock

  1. Select a cell.
  2. In the Date/Time group, click the ‘Insert Time’ button > The time picker will pop up next to the cell.
    Or: right-click and choose ‘Insert time’.
    Or: use a shortcut – press Ctrl+Shift+; (semi-colon).
  3. Set the time by using a scroll wheel or the Up/Down arrows > Press Enter > Done.
    Note the time format: is it what you wanted? Learn how to change the default time format of the Popup Clock.
  4. To change a time entry, click on the Clock icon to the right of the cell > Change time.

The Popup Clock remembers the last used time value, so it is easier to insert time the next time.

Note: after you enter time, the cell is automatically assigned Number/Time format. If you delete the time value later, the cell will still keep its Time format, and the Popup Clock icon will remain available for this blank cell. To remove the icon, change the cell's format to General.

Insert time into a cell from the Popup Clock

 

How to populate an entire column, row or non-adjacent cells range with time

Use the Popup Clock to populate with time values an entire range. You can insert time into table columns, rows, merged cells, non-adjacent cells or any custom range (limitation up to 4000 cells) just the same, as into a single cell:

  1. Select a range.
  2. In the Date/Time group, click the ‘Insert Time’ button > The time picker will pop up next to the cell.
    Or: right-click and choose ‘Insert time’.
    Or: use a shortcut – press Ctrl+Shift+; (semi-colon).
  3. Set the time by using a scroll wheel or the Up/Down arrows > Press Enter > Done. The whole range is populated with the selected time value.
    Tip: learn how to populate cells with consecutive time entries.
  4. To change the time entry in a specific cell, click on the Clock icon to the right of the cell > Change time.

Note: after you enter time, the cells are automatically assigned Number/Time format. If you delete some of the time values later, the cells will still keep their Time format, and the Popup Clock icon will remain available for these blank cells. To remove the icon, change the cells' format to General.

Populate a range with time values from the time picker

 

How to populate a range with consecutive time values

With the Popup Clock you can quickly populate a range with consecutive time entries (sequential hours):

  1. XLTools tab > Settings button > Date/Time tab > Check the box ‘Auto-increment time when I use time picker for a range of cells’ > OK.
  2. Select a range.
  3. In the Date/Time group, click the ‘Insert Time’ button > The time picker will pop up next to the cell.
    Or: right-click and choose ‘Insert time’.
    Or: use the shortcut – press Ctrl+Shift+; (semi-colon).
  4. Pick the starting time value > Done, the whole range is automatically filled with consecutive time values with 1 hour increments.

Populate a range with consecutive time values

 

How to insert both date and time into a cell

  1. Select a cell.
  2. In the Date/Time group, click the ‘Date & Time’ button > The Popup Calendar with Clock will appear next to the cell.
    Or: right-click and ‘Insert Date & Time’.
    Or: use a shortcut – press Ctrl+; (semi-colon), then release the keys and press Ctrl+Shift+; (semi-colon).
  3. Set the time by using a scroll wheel or the Up/Down arrows > Choose a date from the Popup Calendar > Done.
    Note the time format: is it what you wanted? You can change the default format of the Popup Calendar and Clock.
  4. To change an entry, click on the icon to the right of the cell > Change time and date.

Note: after you enter date and time, the cell is automatically assigned Number/Date format. If you delete the value later, the cell will still keep its Date format, and the Popup Calendar with Clock icon will remain available for this blank cell. To remove the icon, change the cell's format to General.

Insert both date and time into a cell from the date picker

 

How to insert only date (without time) into a cell

Use the Popup Calendar date picker to pick and insert dates into cells and ranges:

  1. Select a cell or a range.
  2. In the Date/Time group, click the ‘Insert Date’ button > The Popup Calendar will appear next to the cell.
    Or: right-click and ‘Insert Date’.
    Or: use a shortcut – press Ctrl+; (semi-colon).
  3. Pick a date from the Calendar > Done.

Insert only dates into cells from Excel Popup Calendar

 

How to change the default time format of the Popup Clock

You can change the default time format of the Popup Clock:

  1. Click ‘Settings’ on XLTools ribbon > Date/Time tab.
  2. Check the box ‘Use the Date and Time format below as default’.
    Note: if you uncheck this box, the Popup Clock will use the format specified in your system settings.
  3. Select your preferred format, e.g. the format customary in your country or language.
    Or: choose to ‘Set custom format’.
  4. Click OK > Done.

Set custom time format for the Popup Clock

 

You may find that some cells would not comply with the Clock’s format settings. It means the cells had been assigned a different time format earlier. In this case, change the cells' format:

  1. Select cells > Right-click and choose ‘Format cells’.
  2. Open Number tab > Time format > Select the required time format.

Initially, the Popup Clock employs your system settings for default date and time format. You can change your system settings altogether. Note, this will affect all user accounts on your computer:

  1. Control Panel > Clock, Language, and Region > Region.
  2. Formats tab > Set date and time formats, first day of the week.
  3. Location tab > Set your home country location.
  4. Administrative tab > Change system locale > Restart your computer.

 

For your convenience, the default shortcut for the Popup Clock is Ctrl+Shift+; (semi-colon) – the same combination used in Excel to insert the current time. You can change the Popup Clock shortcut at any time:

XLTools tab > Settings button > Shortcuts tab > Set a different shortcut > OK.

Set shortcuts for the Popup Clock in Excel

 

How to add/remove the Popup Clock icon

The Clock icon appears to the right of a selected a cell, when the cell has Time format. Clicking the icon opens the time picker.

  • To disable the Clock icon:
  1. Click ‘Settings’ on XLTools ribbon > Date/Time tab.
  2. Uncheck the box ‘Display the Popup Calendar and Clock icons’ > OK.
  3. Done! The icons will not display, but the Calendar and Clock will still be availalbe for use. You can bring the icons back at any time.

Hide or display drop-down icons for the Popup Clock in Excel

 

  • To make the Clock icon readily available near a blank cell, column, row or custom range:
  1. Select a blank cell or a range.
  2. Home tab > Number group > Time > OK. This will assign time format to the cells.
    Or: use the Popup Clock to insert any time value > Press Delete. This will remove the actual values and yet assign time format to the selected cells.
  3. Done! Now if you select any cell in this range, the Clock icon will appear near that cell.
  • To remove the Clock icon from empty cells:
    If a cell is empty, but it still has an icon beside it, it means that the cell still has date or time format assigned. To remove the icon from blank cells, change their format back to General:
  1. Select an empty cell or a range.
  2. Home tab > Edit group > Clear formats.
    Or: Home tab > Number group > Select ‘General’ from the drop-down list.
    Or: Right-click > Format cells > Number tab > Select ‘General’ > OK.

 

How to add/remove the Popup Clock from the right-click menu

  1. Click ‘Settings’ on XLTools ribbon > Date/Time tab.
  2. Check/uncheck the relevant boxes:
    • ‘Add “Insert Date” to the context menu’
    • ‘Add “Insert Time” to the context menu’
    • ‘Add “Insert Date & Time” to the context menu’
  3. Click OK > Done.

Remove or add Popup Clock from the right-click menu

 

How to embed a time picker into an Excel spreadsheet

XLTools Popup Clock time picker cannot be embedded into spreadsheets. The Popup Clock is visible and available to other users, only if they also have XLTools installed.

Any questions or suggestions? Please leave your comment below.

Leave a Reply

Your email address will not be published. Required fields are marked *