Keyboard shortcuts to format the date and/or time in a cell.If the format contains an AM or PM, the hour is based on the 12-hour clock, if not, the hour is based on the 24-hour clock.

If you use 'm' immediately after the 'h' (h:mm) or immediately before the 'ss' (mm:ss), Excel displays minutes not month. Shows hours, minutes and seconds with A and P notationĮlapsed time in hours (more than 24 hrs)Įlapsed time in minutes (more than 60 minutes)Įlapsed time in seconds (more than 60 seconds) Shows hours and minutes with AM and PM notation Hours (h), minutes (m), and seconds (s) Code

From the Home tab, click the Number Dialogue Box Launcher.

You can create a custom format for date or time. ** To open the Dialog Box Launcher you can also press CTRL+1 or Right Mouse Click the selection and choose Format Cells. The number in the selected cell on the worksheet, appears in the Sample box³ so you can preview the formatting.

From the Home tab, in the Number group,.

You can however, change any of these formats

For following table shows what format you get on what you enter Format As You Typeĭepending how you enter the Date/Time Excel will give an automatic format. This default format is based on your date and time settings (from Windows Control Panel).Įxcel displays many date and time formats, most of which are not affected by Control Panel settings.ĭisplay numbers as dates or times. When you type a date or a time in a cell, it shows as the default date or time format.

Number dialog box launcher