Merge Date and Time without Losing Time in Microsoft Excel 2010

To merge the date and time in a single column you have to use the “INT” function along with the “MOD” function in Microsoft Excel 2010.

Before we use the formulas together you should know about both the functions individually.

INT: - This function is used to round a number down to the nearest integer.

Syntax of “INT” function: =INT (number)

Example:Cell A1 contains the

number 456.25
=INT (A1), function will return 456

img1

 

MOD: - This function is used to return the remainder after a number is divided by a divisor.

 

Syntax of “MOD” function: =MOD (number, divisor)

 

Example:Cell A1 contains 45 and A2 contains 16
=MOD (A2, A3), function will return 13

img2

 

Let’s take an example and understand how we can add date and time in a single cell without losing the time part of the data.

img3

 

I have a date in cell A2 and the time in cell B2. To merge date and time in a cell follow the below mentioned steps:-

  • Select the cell C2 and write the formula.
  • =INT (A2) +MOD (B2, 1)and press enter on the keyboard.
  • The function will merge the date and time without losing the time part.

img4

 

So in this way, we can merge both the cells ensuring that the time part is correctly reflected in the merged cell.

 

Users are saying about us...

  1. Thanks for publishing the solution to this problem. Although it seems like it should be a common and straightforward issue, the solution is not obvious, there are a number of inappropriate solutions on the web, and the pitfalls are many.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube