which key is used while entering date and time together ,to seprate them one word
Answers
Answer:
Cancel Button is the answer.
Explanation:
please mark me as brainliest
Answer:
To separate date and time follow below given steps:-
Select the cell B1 and write the formula to extract date from cell A1
=INT(A1), press enter
Format this cell as “mm/dd/yyyy”
To format the cell, press the key “CTRL+1”
Format Cells dialog box will appear
image 3
In the “Number” tab select “Custom” in the type box, type the date format as DD/MM/YYYY
image 4
Click on OK
image 5
To separate time follow the below given steps:-
Select the cell B1 and write the formula to extract time from cell A1
=MOD (A1, 1), press Enter
image 6
Format this cell as “h:mm”
To format the cell, press the key “CTRL+1”
The “Format Cells” dialog box will appear
In the “Number” tab select “Custom” in the type box, type the date format as “h:mm”
image 7
Click OK
image 8