<div>
Thank you peter57r. &nbsp;This did not work exactly but it did lead me to the answer. &nbsp;When I tried to use datediff() it kept give me an error<br />
datediff(&quot;h&quot;,{@Convert Avail},{@Convert SFT}) <br />
it would highlight {@Convert Avail} and tell me a date is required here.<br />
But since you said it would convert to seconds which I was not aware of, I simply subtracted one from the other and then wrote a few simple conversions to get hours of service.<br />
so i ended up with {@Convert Avail}-{@Convert SFT} and then converted seconds to hours &amp;&nbsp;minutes<br />
So thanks again for the help
</div>


Thank you peter57r.  This did not work exactly but it did lead me to the answer.  When I tried to use datediff() it kept give me an error
datediff("h",{@Convert Avail},{@Convert SFT})
it would highlight {@Convert Avail} and tell me a date is required here.
But since you said it would convert to seconds which I was not aware of, I simply subtracted one from the other and then wrote a few simple conversions to get hours of service.
so i ended up with {@Convert Avail}-{@Convert SFT} and then converted seconds to hours & minutes
So thanks again for the help

<div>
Forced accept.<br />
<br />
Computer101<br />
EE Admin
</div>


<div>
<div class="content wysiwyg-content">
I have 2 tables where time is being stored as TEXT. &nbsp;I need to convert this Text to a numeric value so that I can subtract the two fields from each other to determine out of service time. &nbsp;The time format is 06:20PM (example) . &nbsp;I am using Crystal Reports 11<br />
<br />
Any help would be appreciated. &nbsp; 
</div>
</div>


I have 2 tables where time is being stored as TEXT.  I need to convert this Text to a numeric value so that I can subtract the two fields from each other to determine out of service time.  The time format is 06:20PM (example) .  I am using Crystal Reports 11

Any help would be appreciated.   

Convert Time in Text Format to Numeric Time format

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.