Cara Rekap Jam Datang dan Pulang di TimeSheet Google Sheet

[@berkassekolah-j8c]

Menghindari hasil jam 0:00:00 bagaimana?

[@qolbaedu]

Pakai IFna =""

[@itdiamulia]

saya N/A pak yang bagian jam check in nya belum bisa ( =index('Form Responses 4'!A2:F;match(E5&E6&B8;'Form Responses 4'!F2:F&'Form Responses 4'!D2:D&'Form Responses 4'!B2:B;0);1) mhn dibantu pak

[@bangziechannel]

sama berti pak muncul N/A

[@itdiamulia]

hasil rumus nya saya N/A pak (=index('Form Responses 4'!A2:F;match(E5&E6&B8;'Form Responses 4'!F2:F&'Form Responses 4'!D2:D&'Form Responses 4'!B2:B;0);1) mhon dibantu pak

[@divasafiraputri87]

iyaa saya juga munculnya N/A