国产成人AV一区二区三区在线_国产成人精品无码免费看_国产成人无码无卡在线观看_国产精品成人A区在线观看_国产日韩精品欧美一区_国产亚洲精品自在久久蜜TV_久草热久草热线频97精品_久久久噜噜噜久久中文福利_久久婷婷五月综合色国产免费观看_日日狠狠久久偷偷色综合0,九一桃色在线观看,久久97精品久久久久久久不卡,国产成人精品亚洲精品

求excelvba代碼

訪客2023-12-15 10:11:2610

求大俠把下面的語句改寫成VBA代碼

H2=IF(E2="",MID(D2,1,2)&"日，周"&RIGHT(D2,1)&"上午沒打卡",IF(E2-$E$1<=0,"",MID(D2,1,2)&"日,，周"&RIGHT(D2,1)&"遲到"&MINUTE(E2-$E$1)&"分鐘"))

非常感謝求excelvba代碼

If [E2] = "" Then

[H2] = Left([D2], 2) & "日,，周" & Right([D2], 1) & "上午沒打卡"

ElseIf [E2] - [E1] <= 0 Then

[H2] = ""

Else

[H2] = Left([D2], 2) & "日,，周" & Right([D2], 1) & "遲到" & Minute([E2] - [E1]) & "分鐘"

End If

在淘寶上面看看

Tags：代碼excelvba

文章評(píng)論