excel常用公式

年时间进度

=(TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY())+1,1,1)-DATE(YEAR(TODAY()),1,1))

 

秒数转为时分秒

=TEXT(A1/86400,"hh:mm:ss")

=TEXT(A1/86400,"h小时m分钟s秒")