Displays date and time serial numbers as date values, according to the type and location that you specify
- Select a cell or a cell range.
- Right-Click, Select “Format Cells“
- Select “Time”
Or Press “CTRL + 1” and select “Time“ Tab
- To specify Time type, We can change it from “Type” box
- To specify Time type, According how another language display date, choose it from “Locale (Location)” box