Re: What are the units for the Date Difference function?

Home Forum Behaviors What are the units for the Date Difference function? Re: What are the units for the Date Difference function?

#4401

Anonymous

Is there a way to merge the date and time fields together? I need to calculate the difference between a specific start date and time with that of another.

Example:

An employee’s shift could start on 03/05/2009 06:30:00 PM and end on 03/06/2009 05:30:00 AM

I need to be able to calculate the # of hours the employee worked, which in this scenario would be 11 hours.

Charles