On one of my tables, the user inputs a time value on how long the Production line has been down. Now in the table, the field LineStopTime is set to format LongTime. I have a query set up which transports some data to excel, including this time. I have now noticed that it outputs and AM/PM time, and what i want to record is the hours/minutes/seconds that the line goes down. I'm not sure what to change this to, does anybody know whats best to do?
Even just showing hrs and minutes will do, even just minutes if need be
Even just showing hrs and minutes will do, even just minutes if need be
