Insert Time in Google Sheets: Entry, Shortcuts & Formulas

To insert a time in Google Sheets, select a cell and type a value such as 9:30 AM or 14:30, then press Enter. For the current time, use Ctrl+Shift+; on Windows or Command+Shift+; on Mac. Format the cell as a time if the value does not display as expected. You only need a Google account and a spreadsheet open in a web browser; the steps below cover typing, shortcuts, formulas, and common fixes.

What You’ll Need

A Google account with access to a Google Sheets file.
A web browser and a cell or column where you want the time to appear.
If you are entering times for a schedule or log, decide whether you want a fixed time, such as a meeting start, or a formula that updates, such as the current time.

Google Sheets stores times as fractions of a 24-hour day. The value 12:00 PM represents halfway through the day, for example. The number format controls how that value appears, so one cell may show 2:30 PM while another shows 14:30. This guide is for Google Sheets in a web browser; Excel stores time values similarly, but its menu paths and some keyboard shortcuts differ.

Step-by-Step

Open the sheet and select a cell. Click the cell where the time should go. If you are adding times to a list, consider using one column for the time and a header such as Start time or Check-in. To enter several values, you can select the first cell, type a time, press Enter, and continue down the column. For a time log, it can help to keep dates in a separate column so entries from different days are not confused.
Type a time in a recognizable format. Enter a value with a colon, such as 9:30 AM, 9:30 pm, or 14:30, and press Enter. Google Sheets generally recognizes these as times. Use AM or PM when entering a 12-hour value if there is any chance of ambiguity. In a 24-hour value, 14:30 means 2:30 PM. If you enter just 9, Sheets may treat it as the number 9 rather than 9:00 AM, so include minutes or apply an intentional time format.
Set the display format if needed. Select the cell or range, then choose Format > Number > Time to display a standard time. Choose Format > Number > Custom date and time if you want to choose a more specific display, such as hours and minutes without seconds. You can also use Format > Number > Duration for elapsed time, such as the length of a shift. Formatting changes how the value looks; it does not change the underlying time.
Insert the current time with a keyboard shortcut. Select the target cell and press Ctrl+Shift+; on Windows or Command+Shift+; on Mac. The shortcut inserts the current time as a fixed value, so it will not keep changing when the sheet recalculates. If the shortcut does not work with your keyboard layout or browser, type the time manually instead. The shortcut uses the spreadsheet’s time zone setting, so check that setting if the inserted time seems offset.
Use a formula when you need a calculated or updating time. To create a particular time from hour, minute, and second values, enter this in a cell: =TIME(14,30,0). It returns 2:30 PM when displayed with a standard time format. This is useful in templates because you can change the hour or minute arguments without retyping a time string. For instance, changing the first argument to 9 and the second to 15 gives 9:15 AM.
Choose between a fixed timestamp and a live clock. A manually entered time or the keyboard shortcut is appropriate for recording when an event happened because the value stays put. If you want a cell to show the current date and time and update as the sheet recalculates, enter =NOW(). In the cell containing this formula, the displayed result is the current date and time, not a permanently saved timestamp. To show only the time, apply Format > Number > Time. Remember that a live formula can change later, so it is usually unsuitable as an audit trail or an unchanging check-in record.
Enter times consistently down a column. After entering and formatting the first time, select the remaining cells and apply the same number format using Format > Number > Time. Type each time with a colon, then press Enter to move to the next row. Consistency matters when you later sort, compare, or calculate with the entries. If different people will edit the sheet, add a note to the column header saying whether to use AM/PM or 24-hour time.
Optionally calculate an end time. If A2 contains a start time of 9:15 AM and B2 contains a duration of 2:30, enter =A2+B2 in C2. The result is 11:45 AM when C2 is formatted as a time. Here B2 is a duration of two hours and thirty minutes, not a clock time intended to identify a point in the day. Format B2 as a duration if you want it displayed clearly as elapsed time. This simple addition is useful for appointments or shifts that do not cross midnight.

Common Mistakes

Entering a number without a colon. A value such as 9 may be interpreted as a number rather than nine o’clock. Enter 9:00 AM or 09:00 to make your intention clear.
Mixing up AM and PM. In 12-hour notation, 7:00 AM and 7:00 PM are twelve hours apart. Include the AM/PM marker or consistently use 24-hour notation when entering schedules.
Confusing a time with a duration. A clock time such as 2:30 PM identifies a point in the day; a duration of 2 hours and 30 minutes measures elapsed time. Use the Time format for clock times and Duration for elapsed values.
Expecting NOW to create a permanent record. =NOW() can recalculate, so it is not a fixed timestamp. Use the keyboard shortcut or type a time directly when the value must remain unchanged.
Changing the format but not the value. Number formatting changes the display, not what was entered. If Sheets has stored text instead of a time, applying a time format alone may not convert it into a usable time value.

Tips

Pick one time convention for the whole sheet. Use either 12-hour time with AM/PM or 24-hour time, especially when several people enter data. A consistent convention makes scanning and checking entries easier.
Set a format before filling a large range. Select the target column and choose Format > Number > Time before entering many values. You can then check a few entries to confirm that they display correctly before continuing.
Keep dates with times for records that span days. A time alone does not say which day an event occurred. Use a separate date column, or store a date-time value when the full timestamp matters. This avoids treating two entries at 9:00 AM on different dates as if they were the same event.
Check the file time zone for current-time entries. Open File > Settings and review the time zone. This is particularly important when collaborators work in different regions or when a current-time formula or shortcut appears several hours off.
Use a keyboard shortcut for a record, not a running clock. The current-time shortcut gives you a convenient fixed value. A formula is better for a value that should update. Choosing the right method at the start prevents later confusion about whether a timestamp represents the original entry time or the present moment.

Troubleshooting

The cell shows a decimal or an unexpected number. The entry may be stored as a time but displayed with a number format. Select it and choose Format > Number > Time. If the value still looks wrong, double-click the cell and check whether you entered a colon and an appropriate AM/PM marker.

The entry stays aligned left or will not calculate. It may be stored as plain text. Edit the cell and re-enter the time in a recognizable form, such as 8:45 AM, then press Enter. Check whether the cell or column was previously set to plain text or contains an apostrophe before the value. If a whole imported column is affected, test one corrected entry in a spare cell before replacing the original data.

The shortcut inserts a different character or does nothing. Confirm that the cell is selected and that you are using the shortcut for your operating system: Ctrl+Shift+; on Windows or Command+Shift+; on Mac. Keyboard layouts, browser settings, or other shortcuts can interfere. Type the time manually as a reliable alternative, and make sure you are editing the sheet rather than a browser address bar or another control.

The displayed time is several hours off. Check File > Settings for the spreadsheet’s time zone. Also consider whether a collaborator or imported data source uses a different zone. Changing the display format will not correct a time-zone mismatch; confirm the intended zone before changing settings in a shared file.

The result of adding a duration looks strange. Confirm that the start time and duration are in separate cells and that both are numeric time values rather than text. Apply Time to the result and Duration to the elapsed-time cell. For work that can pass midnight, include the date or use a duration display so that an elapsed total is not mistaken for a clock time on the same day.

Frequently Asked Questions

How do I insert the current time in Google Sheets?
Select a cell and press Ctrl+Shift+; on Windows or Command+Shift+; on Mac. This inserts a fixed time. Use =NOW() only if you want a formula that can update when the sheet recalculates.

How do I enter time without AM or PM?
Use 24-hour notation, such as 16:20 for 4:20 PM, and apply Format > Number > Time. Check the display afterward to make sure the chosen format matches what you expect.

Can Google Sheets add hours and minutes?
Yes. Add a time value to a duration value, then format the result as a time. For a shift or total that can exceed a day, use a duration format and include dates when the calendar day matters.

Why does Google Sheets show a number instead of a time?
The value may be using a number format. Select the cell and choose Format > Number > Time. If that does not help, check whether the entry is text rather than a recognized time.

Does a time entered with the shortcut update automatically?
No. The shortcut inserts a fixed time value. A formula such as =NOW() can recalculate, so use the shortcut for a timestamp that should stay unchanged.

Can I display seconds?
Yes. Select the cell and open Format > Number > Custom date and time, then choose a format that includes seconds. This affects the display; it does not add seconds to a value that was entered without them.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.