How to extract Date, Time into two separate cell from Timestamp in Excel ?

MS Excel @ Freshers.in

Consider you have a date timestamp value in cell A1

A1 = 01/21/2022 11:35 PM

You want to extract date and time into two separate cells

Extract date 
First change the cell type to Date ( Home->Format->Format Cells->Date)
Use this below formula.

= INT(A1)

Extract time
First Change the cell type to Date ( Home->Format->Format Cells->Time)
Use this below formula.

= MOD(A1,1)
Author: user

Leave a Reply