RoxanneZieglerQrew Assistant Captain9 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 Cadet9 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 deliveryFormula Date Time Will not Accept Null ConditionAudi Log TIME (ISO-8601) ConversionTime CalculationCalculating 1.5 pay