RoxanneZieglerQrew Trainee7 years agoCalculation for Time In and Time Out form I have 3 fields Time In ( time field) Time Out ( time field) Total Time (Duration field) I want it to convert to amount of time spent at work Time In 10am Time out 2 pm = total time of 4 hours ...Show More
MichelleMichellQrew Cadet7 years agoAre you sure you entered AM for Time In and PM for Time Out? If it's getting -8.00, then it could be that they are entered either both AM or both PM.
Related ContentTime CalculationTime of Day field values are not in 24-hour format in PipelinesSet Current Time?Convert timestamp to Date/Timetime duration
Recent DiscussionsFilter Monthly, Quarterly, Yearly from one Date fieldExtrapolating nuanced dataSolvedForms helpShare your feedback on the new Qrew DiscussionsGenerating QR Code with URL to record