<div>
Date and time are recognised in Excel as a serial number. For example 31/07/15 12:15 as a number would be 42216.51 &nbsp;the 42216 being the serial number for the date 31/07/15 and .51 being the portion of a day, ie the decimal portion of the integer.<br />
<br />
MOD function divides the number by a factor and gives the remainder, so dividing by one gives you the decimal remainder.<br />
<br />
Thanks<br />
Rob H
</div>


Date and time are recognised in Excel as a serial number. For example 31/07/15 12:15 as a number would be 42216.51  the 42216 being the serial number for the date 31/07/15 and .51 being the portion of a day, ie the decimal portion of the integer.

MOD function divides the number by a factor and gives the remainder, so dividing by one gives you the decimal remainder.

Thanks
Rob H

<div>
thanks Rob, I somehow knew you would know the answer to that one.
</div>


thanks Rob, I somehow knew you would know the answer to that one.

<div>
<div class="content wysiwyg-content">
if I have a time in cell P4 like 12:00 and a date and time in cell T4 like 31/07/2015 12:15<br />
<br />
what would be the formula to say<br />
<br />
If T4 [Time] is less than P4, Yes, No<br />
<br />
I thought maybe something like <br />
<br />
=IF(RIGHT(T4,5)&lt;=P4,&quot;Yes&quot;,<wbr />&quot;No&quot;)
</div>
</div>


if I have a time in cell P4 like 12:00 and a date and time in cell T4 like 31/07/2015 12:15

what would be the formula to say

If T4 [Time] is less than P4, Yes, No

I thought maybe something like 

=IF(RIGHT(T4,5)<=P4,"Yes","No")

Help with formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.