Dear Sir,
I want to calculate time ( Based on Start Time and End Time) in a query (Sample db is attached) I tried couple of methods to achieve the required result.
By setting up field to "Number" in Mehtod1 Table calculates as number but can't set as HH:NN. Method 2Table can't restrict input more than 60 Minutes.
Your Kind Advise/ Help are really appreciated
I want to calculate time ( Based on Start Time and End Time) in a query (Sample db is attached) I tried couple of methods to achieve the required result.
By setting up field to "Number" in Mehtod1 Table calculates as number but can't set as HH:NN. Method 2Table can't restrict input more than 60 Minutes.
Your Kind Advise/ Help are really appreciated