查出的数据是六位的类似于060741、192744怎么调整为时分秒形式,06:07:41这种,使用format($$$,"hh:mm:ss")无效,设置时间之后就会全部变成八点
CONCATENATE(left("060741",2),":",mid("060741",3,2),":",right("060741",2))
CONCATENATE(left(192744,2),":",mid(192744,3,2),":",mid(192744,5,2))