I would like to be able to calculate the hours worked from the 3rd party bundled solution by FieldAware. The bundle is locked, so I can't see details, but do know they have a custom record titled FieldAware Job Worked Hours. In it, they have FieldAware Job Worked Hours : End time and FieldAware Job Worked Hours : Start time. The format of these fields is mostly likely Text and looks like 4/26/2019 114032 am. The times are in 12 hour format. I am trying to create a formula in a Saved Search that will provide the calculation. It is not working and I get the Error: Invalid Expression message when running my Saved Search. This is what I have so far, tried a variation of combinations and could not get it to work yet. Any help would be greatly appreciated. EXTRACT (HOUR FROM (to_timestamp({FieldAware Job Worked Hours : End time}, 'DD-MM-YYYY HH12MISS AM'), 'HH24:MI') - to_timestamp({FieldAware Job Worked Hours : Start time}, ‘DD-MM-YYYY HH12MISS AM’), 'HH24:MI')) || ':' || EXTRACT (MINUTE FROM (to_timestamp({FieldAware Job Worked Hours : End time}, ‘DD-MM-YYYY HH12MISS AM '), 'HH24:MI') - to_timestamp({FieldAware Job Worked Hours : Start time}, ‘DD-MM-YYYY HH12MISS AM’), 'HH24:MI'))