BEGIN{ } { date = $1 cantemp = $2 voltage = $3 current = $4 } END{ dday = int(date); if ( dday != day ){ printf("Days don't match\n"); } hour = ( date - day) * 24; hour -= offset; cantemp = ( cantemp * 1.8 ) + 32 printf ( "%04.1f %.0f %.2f %.2f \n",hour, cantemp, voltage , current ) }