Excel handles dates and time using a scheme in which dates are serial numbers and times are fractional values. For example, **June 1, 2000 12:00 PM** is represented in Excel as the number 36678.5, where 36678 is the date and .5 is the time.

If you have dates with time values and you want to extract *only the time portion* (the fractional part), you can use a formula that uses the MOD function. Assuming A1 contains the date and time value **June 1, 2000 12:00 PM**, the formula below will return just the time portion (.5):

### How this formula works

The MOD function returns the remainder from division. The first argument is the number and the second is the divisor. Here are a few examples:

=MOD(5,2) // returns 1 =MOD(7,5) // returns 2

So, if you use MOD with a divisor of 1, the result will be the fractional part of the number, if any, because every whole number can be evenly divided by itself. For example:

=MOD(3.125,1) // returns 0.125

In short, =MOD(number,1) returns just the fractional part of a number, discarding the integer portion, so it's a convenient way to extract time from a date and time.

Note: if you use this formula to strip the time from a date + time, you'll need to adjust the number format to a suitable time format.