Excel - Adding seconds to time and date - Microsoft Community Currently we are importing data and then changing the date and time using a custom format to mm dd yyyy hh:mm:ss and then saving as a CSV When we reopen the file the time has left off the seconds,