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 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 deliveryQrew Tip: Calculations per RecordURL for current time in Time of Day fieldSet Current Time?Audi Log TIME (ISO-8601) Conversion