Combine date and time in Excel and Google Sheets

=TEXT(A2,"m/dd/yy ")&TEXT(A3,"hh:mm:ss")

A2 = date cell; A3 = time cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Combine date and time in Excel

How to combine date and time in Excel?
Combine date and time in Excel

COMBINE DATE AND TIME β€” EXCEL FORMULA AND EXAMPLE

=TEXT(A2,"m/dd/yy ")&TEXT(A3,"hh:mm:ss")

  • A2 = date cell, A3 = time cell

  • "m/dd/yy " = format – The pattern by which to format the number, enclosed in quotation marks

  • "hh:mm:ss" = format – The pattern by which to format the number, enclosed in quotation marks

  • & = combine both date and time

πŸ’‘ The result will be stored as a text value

Combine date and time in Google Sheets

How to combine date and time in Google Sheets?
Combine date and time in Google Sheets

COMBINE DATE AND TIME β€” GOOGLE SHEETS FORMULA AND EXAMPLE

=TEXT(A2,"m/dd/yy ")&TEXT(A3,"hh:mm:ss")

  • A2 = date cell, A3 = time cell

  • "m/dd/yy " = format – The pattern by which to format the number, enclosed in quotation marks

  • "hh:mm:ss" = format – The pattern by which to format the number, enclosed in quotation marks

  • & = combine both date and time

πŸ’‘ The result will be stored as a text value

Other widely used Excel and Google Sheets functions explainedOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions