script for only consolidation and time conversion