expression builder

[shakermaker]

Hi there,
FULL STORY
I am keeping a time of how long it takes my staff to do there production jobs. I have set up an expression builder that works out the difference between the start time & the finish time of a job... giving me a total time for the job. BUT, i would have added 2 yes/no fields to my form (Break & Lunch) and when ticked the expression builder of the job time will take into account that the job time includes there lunch break.

I.E. The job instead of taking 3 hours, when break field is ticked expression builder takes of 30 minutes... job time is then 2 hrs 30 mins to complete.

Confusing but please help me

Thanks
Neil

 

[namliam]

something like:

[EndTime]-[StartTime]-iif([break];cdate("0:30");0)-iif([Lunch];cdate("0:30");0)

Might need to change ; to ,

Good luck