RoxanneZieglerQrew Assistant Captain8 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 Cadet8 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 ContentTrying to calculate On Time deliveryAudi Log TIME (ISO-8601) ConversionCalculating 1.5 payHelp with Calculating Average Completion Time Over Several RecordsFormula Date Time Will not Accept Null Condition