Creator : Calculate Hours/Minutes between two time fields
Creator : Calculate Hours/Minutes between two time fields
I have two time fields and need to know how many hours and minutes there are between them (and convert to decimal if possible). Every thing I've tried is either for datetime data types; won't let me do calculations on time fields or the function timeBetween() doesn't exist for creator.
This is further complicated by the start/end time data being held in a subform called Operating_Schedule.