format correct wallclock timestamps and add GMT to local conversion