A certain situation may arise when we need to combine the separately put DATE and TIME in excel. For this, we can again use very simple steps.
CONCEPT:
If we remind the basics of DATE AND TIME , we know that both are handled together by Excel.
The integral part of the number is the date and decimal part of the same is time for Excel.
The format in which we see the date and time are just the format. While calculating, Excel treats the date as an integer and time as a decimal portion of the same.
For example Jan,1,2020 , if represented as the DATE SERIAL evaluates to 43831.
Similarly 12 PM [noon] evaluates to 0.5.
Now if we simply sum the Date and Time, our problem is solved. As the sum won’t interfere with each other.
STEPS TO COMBINE DATE AND TIME IN EXCEL
- The solution is very easy. As we know the date is a number and time is the fractional part associated with the same number.
- Enter the following formula in third cell “=cell containing the date+cell containing the time” [“” not included].
- Convert the number format to DATE if needed.