These fields appear as example 08:55 42 and 09:12 32

I want to create a new field which gives me the time difference between the two.

I thought I could just do it like

 

DateDiff ("n", {@CreateTime}, {@STATTME})

 

I get an error message saying a date is required here.

Is this because of the way my time is formatted?

Anyone know of anyway around this?

I'm new to crystal and any help would be greatly appreciated.

 

Thanks but no luck.

I literally just changed my formula to what you have there and I'm still getting the same error.

'There is an error in your formula, do you wish to save anyway?'

and then it highlights {@CreateTime}  and says a number is required here.... Any other ideas?

 

 

HelpDeskTimeToTimeString({TABLE1.TIME})

 

Time is stored like '13670947600' and that converts it to 08:38:05

 

Time is stored like '13670947600' and that converts it to 08:38:05

So its not a time field originally unfortunatley :-( ....Hmmmmmm......

 

Legend! Thanks a million, much appreciated!!!!!!