MS Excel in Bangla > Formatting

How to Format Date-Time

17.4k

To apply the Format function, we need to select the cell that contains the date-time value and then type a comma after it. After that, we should type "Format" and then press Enter on our keyboard. The screen will show us two options - General and Custom.

  • Select the cells you want to format.
  • Press CTRL+1.
  • In the Format Cells box, click the Number tab.
  • In the Category list, click Date.
  • Under Type, pick a date format.
  • If you want to use a date format according to how another language displays dates, choose
  • the language in Locale (location).

The following is a list of shortcuts for formatting date-time in MS Excel:

  • Ctrl + Shift + R - Format cells as date.
  • Ctrl + Shift + D - Format cells as time.
  • Ctrl + Shift + T - Format cells as time with am/pm.
  • Ctrl + Shift + H - Format cells as 24 hour clock.
  • Ctrl+Shift+ A – Apply the same formatting to all cells in the selection.

You can use the Preview tab to see how your changes will look before you apply them to your document. You’ll also be able to see how the formatting will change for each paragraph, including lists and headings. Previewing formatting changes before applying them is a great way to make sure that you are not wasting time on formatting that will not be used.

As previously stated, the excel time format code is hh:mm:ss. Let me now go over this code in detail. hh: This time code is a double-digit figure that reflects the hour component of the time. For example, in the preceding example, our time value was 06; however, if you merely say "h," the hour part will only be 6, not 06.

Learner's Ratings

4.7

Overall Rating

  • 83%
  • 10%
  • 4%
  • 3%
  • 0%

Reviews

P
Prabhat Yadav
5

Superb and amazing 😍🤩 enjoyable experience.

P
pritam chakraborty
5

very good

S
Sudip Sadhukhan
5

Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you

S
sadananda basak
5

Teaching technique is easy to understand. Thanks.

J
Joydeep
5

nice

U
Uttam Nandi
5

Very nice teaching.

R
RABIN DEY
5

REALLY HELPFUL COURSE

S
Subhasis Bosu
5

good

A
Anamul Huq
5

This is helpful how are zero to intermediate level.

S
Souvik Dutta
4

very good course

Show More
Course Content

  1. How to Work with Menu Bar
    5m 39s
  2. How to use LearnVern
    3m 20s
  3. What is Quick Access Toolbar and How to Work with it
    6m 33s
  4. How to Work with Formula Bar
    2m 35s
  5. What is Status Bar and How to Work With it
    5m 33s
  6. How to Navigate within Sheet and Workbook
    3m
  7. How to use Shortcuts
    4m 3s
  8. What is Format Painter and How to work with it
    2m 25s

  1. How to Enter Data in MS Excel
    4m 58s
  2. How to Use Autofill Functionality
    5m 32s
  3. How to Enter Date-Time
    6m 11s
  4. How to Use Undo-Redo
    5m 17s
  5. How to Work With Comments in MS Excel
    3m 29s
  6. How to Save Workbook in MS Excel
    4m 16s

  1. How to Create Formula in MS Excel
    7m 40s
  2. How to Copy Formula in MS Excel
    3m 31s
  3. How to Use Till Date Profit Formula
    3m 37s
  4. How to Work with Percentage Change Calculation
    5m 22s
  5. How to Use Absolute Value
    6m
  6. How to Use Sum Average
    5m 28s
  7. Which are the Common Functions
    7m 39s

  1. How to Format the Fonts
    3m 41s
  2. How to Adjust Rows and Columns
    3m 57s
  3. How to Use Alignment
    7m 3s
  4. How to Format the Borders
    2m 56s
  5. How to Format Numbers
    3m 52s
  6. How to Format Date-Time
    9m
  7. How to Use Conditional Formatting
    9m 6s
  8. How to Format Tables
    9m 1s
  9. How to Format Shapes
    6m 49s

  1. How to Resize Row & Column
    7m 2s
  2. How to Hide-Unhide Row & Column
    5m 23s
  3. How to Copy ,Move & Insert Data
    5m 28s
  4. How to Find and Replace Data
    6m 32s

  1. How to Print
    8m 33s
  2. What is Page Break Preview & How to Set Page
    5m 21s
  3. How to Set Page
    4m 57s

  1. How to create Charts
    7m 10s
  2. Which are the different types of Chart
    5m 37s
  3. How to Format Charts
    6m 31s
  4. Which are the Chart Elements
    7m 42s
  5. How to Use Spark lines
    7m 54s

  1. How to Freeze-Unfreeze the Row & Column
    7m 26s
  2. How to Split the Sheet
    6m 50s
  3. How to Use Outline
    6m 59s

  1. How to Manage Multiple Workbook
    6m 37s
  2. How to Use Rename Insert hide unhide sheets
    4m 38s
  3. How to Copy & Delete Sheets
    6m 30s
  4. How to Use Formula
    9m 4s
  5. How to Edit Links
    9m 12s

  1. What is IF Condition and How to Use it
    6m 25s
  2. What is VLOOKUP and How to Use It
    5m 59s
  3. What is VLOOKUP Exact
    4m 9s
  4. How to Use COUNT IF
    4m 23s

  1. How to Protect Sheet
    4m 52s
  2. How to Secure Workbook
    6m 7s
  3. How to Set Password in Workbook
    2m 19s
  4. How to Share Workbook
    3m 9s
  5. How to Track Changes
    5m 34s

  1. How to Perform Sorting
    6m 35s
  2. How to do Subtotals
    7m 26s
  3. How to Perform Filter
    5m 31s
  4. How to Spilt Data
    4m 20s
  5. How to Use Flash Fill
    3m 35s
  6. How to Remove Duplicate Data
    2m 34s
  7. How to Validate Data
    6m 51s

  1. How to Create Pivot Table in MS Excel
    11m 6s
  2. How to Manipulate Pivot Table
    8m 19s
  3. How to Add Slicers
    4m 36s
  4. How to Perform Grouping of Pivot Table
    4m 39s

  1. What is Macro And How to Use It
    7m 25s

  1. Assignment Q-1
    1m 10s
  2. Assignment Q-2
    21s
  3. Assignment Q-3
    34s
  4. Assignment Q-4
    50s
  5. Assignment Q-5
    48s
  6. Assignment Q-6
    37s
  7. Assignment Q-7
    47s
  8. Assignment Q-8
    45s
  9. Assignment Q-9
    37s
  10. Assignment Q-10
    32s
Enroll For Free