<div>
That means the value in Dwell is a true time value.<br />
<br />
In Excel time values are stored as numbers with 1 representing 24 hours, 0.5 12 hours and 21 hours, i.e. 9:00 PM, as 0.875.<br />
<br />
So your formula is returning the last 2 digits of 0.875, 75.<br />
<br />
What are you trying to do with the formula?
</div>


zachvaldez

<div>
Norie, Ideally, you should also take care of the date component....just in case.
</div>


<div>
Just apply the format <b>AM/PM</b> to target cell, and then a direct reference:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-43285465-1"><span>=D2</span>
</code></pre>
</div>


<div>
ex &nbsp;excel date time column format is 4:30:00. I want to display as 4:30
</div>


<div>
Just apply the format <b>h:nn</b> to the cell, ...
</div>


<div>
Two comments from above:<br>1) Norie, Ideally, you should also take care of the date component....just in case.<br><br>2) =IF(D2&gt;=0.5, "PM', "AM")<br><br>The result would be:<br>=IF(D2-INT(D2)&gt;=0.5,"PM","AM")<br><br>If there could be a date in some but not others:<br><br>=IF(MAX(1,D2-INT(D2))&gt;=0.5,"PM","AM")&nbsp;
</div>


<div>
Rob, that's not how Format nor the Format property work. A specified format doesn't work sometimes or maybe. <br />
There will be no &quot;just in case&quot;.
</div>


<div>
Oh, missed that, sorry. By why (Norie) reinvent the wheel?
</div>


<div>
@Zachvaldez - if you explain more as to why you need to determine whether AM or PM there may be a neater solution. I am aware that working with times can be a bit of a pain but there are a number of things that can be done to ease the pain.
</div>


<div>
<div class="content wysiwyg-content">
I have a time field in a column.<br />
9:00 PM<br />
I used the Right function<br />
=Right(D2,2) but it returned 75. not PM
</div>
</div>


I have a time field in a column.
9:00 PM
I used the Right function
=Right(D2,2) but it returned 75. not PM

parsing time field

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.