Does anyone know a way to truncate a time field. So it only shows hours and minutes but no seconds. But i still need it to be able to calculate elapsed time.

I'm working on setting up a time card type of system for workers to log their time on jobs and the 'seconds' is causing some issues of the human element type.

Any suggestions would be greatly appreciated.

Thanks

Kevin

Download Sample!

Sample above will show different ways to truncate and calculate time.

The important bit is to show how you can move between the different field types to achieve what you want.

DataEase converts on the fly between text, dates, time, numbers, numeric string etc.