I need to keep the duration of a specific event (time) in a table. This is the cycle time for a machine to manufacture a part and later will be used to calculate production ratio of the machine.
I used date/time data type for the field, but when I input 1:00:30 (1 hours, 00 minutes, 30 seconds) 1:00:30 PM.
Any kind of advice is much appreciated.
I used date/time data type for the field, but when I input 1:00:30 (1 hours, 00 minutes, 30 seconds) 1:00:30 PM.
Any kind of advice is much appreciated.