# 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 β 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 β 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