Calculating a Time in Crystal Reports

DateDiff is a function that is present to calculate the difference in time. You can explore different options in this function to present the difference in sdays, months etc.

I tried to use DateDiff but since the time field is formatted as a number I get an error. Any suggestions as to how to convert the time from a number to a time? Thanks!

It has been a while since trying this but take a look to see if you can convert the time using the formula either IsTime(number) or TimeValue(number) then once converted you might be able to get the difference.

Time is generally stored in Lawson as HHMMSS in a long integer. So you need to combine 1) convert to text, 2) extract HH, MM, and SS separately, recombine into a Crystal Time variable. Off the top of my head, it's something like this:
time(left(totext({field},"000000"),2),mid(totext({field},"000000"),3,4),right(totext({field},"000000"),2))=

Thank you. I was able to get the time calculation.