A numeric Sheets timestamp contains a date component and a fractional-day time component. You can separate those parts without discarding the original timestamp.
Confirm the source representation
Check whether A2 contains a genuine numeric date-time value or imported text. Text timestamps with offsets need a defined parsing process before numeric formulas can be trusted.
Retain the original field, including any source time-zone information. A displayed time alone cannot establish which instant an external system intended.
Extract the numeric parts
For an ordinary modern positive timestamp, =INT(A2) returns the whole-day date portion. Format that result as Date. =MOD(A2,1) returns the fractional time portion; apply a Time format.
These operations separate parts of the stored number. They do not convert from one time zone to another or interpret a trailing UTC offset embedded in a string.
Verify reconstruction and boundaries
Check that adding the two numeric parts reproduces the original value within normal numeric precision. Test midnight, noon, and a timestamp close to the next day.
Inspect the spreadsheet time zone and the source’s convention before grouping records by the extracted date. A transaction near midnight may belong to another business day after an actual zone conversion. Avoid replacing the full timestamp with its displayed date if later audit or ordering needs the time. Keep empty and malformed source records flagged rather than turning them into a numeric zero, which could masquerade as a valid date origin. Label extracted columns clearly so readers do not mistake a presentation split for an independently verified timestamp conversion.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.