Formatting & Small Formulas

1. SEPARATE THE DATE, MONTH AND YEAR 

Separate the Date Month & Year in the given format. 

Example:

Date:- '=TEXT(E5,"DD")'

Month:- '=TEXT(E5,"MMM")'

Year:- '=TEXT(E5,"YY")'

2. SEPARATE THE TIME AND DATE 

Separate the Time & Date in the given format. 

Example:

Time:- '=TIME(HOUR(E13),MINUTE(E13),SECOND(E13))'

Date:- '=INT(E13)'

3. MERGE START TIME & END TIME IN THE CELL 

Merge the Start Time & End Time in the one cell from given format. 

Example:

=CONCATENATE(TEXT(E29,"hh:mm")&" - "&TEXT(F29,"hh:mm"))