{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Lembar Waktu"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Lembar Waktu","index":0,"n_rows":12,"n_cols":7,"rows_kept":12}
[null,"Lembar Waktu"]
[null,"Detail Karyawan:","Nama","Email","Telepon"]
[null,"Detail Manajer:","Nama"]
[null,"Tanggal Mulai Periode","Tanggal Akhir Periode"]
[null,"Total Jam Kerja \nDalam Seminggu","Total Jam Kerja","Jam Reguler","Jam Lembur"]
[null,{"v":40,"d":"40.00"},{"$f":"SUBTOTAL(109,LembarWaktu[Jam Kerja])","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF(C6<=JamKerjaDalamSeminggu,C6,JamKerjaDalamSeminggu),\"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(C6-D6, \"\")","v":{"v":0,"d":"0.00"}}]
[null,"Tanggal","Waktu Masuk","Mulai Makan Siang","Selesai Makan Siang","Waktu Pulang","Jam Kerja"]
[null,"Tanggal","Waktu Masuk","Mulai Makan Siang","Selesai Makan Siang","Waktu Pulang",{"$f":"IFERROR(IF(COUNT(LembarWaktu[[#This Row],[Waktu Masuk]:[Waktu Pulang]])=4,(IF(LembarWaktu[[#This Row],[Waktu Pulang]]<LembarWaktu[[#This Row],[Waktu Masuk]],1,0)+LembarWaktu[[#This Row],[Waktu Pulang]])-LembarWaktu[[#This Row],[Selesai Makan Siang]]+LembarWaktu[[#This Row],[Mulai Makan Siang]]-LembarWaktu[[#This Row],[Waktu Masuk]],IF(AND(LEN(LembarWaktu[[#This Row],[Waktu Masuk]])<>0,LEN(LembarWaktu[[#This Row],[Waktu Pulang]])<>0),(IF(LembarWaktu[[#This Row],[Waktu Pulang]]<LembarWaktu[[#This Row],[Waktu Masuk]],1,0)+LembarWaktu[[#This Row],[Waktu Pulang]])-LembarWaktu[[#This Row],[Waktu Masuk]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Tanggal","Waktu Masuk","Mulai Makan Siang","Selesai Makan Siang","Waktu Pulang",{"$f":"IFERROR(IF(COUNT(LembarWaktu[[#This Row],[Waktu Masuk]:[Waktu Pulang]])=4,(IF(LembarWaktu[[#This Row],[Waktu Pulang]]<LembarWaktu[[#This Row],[Waktu Masuk]],1,0)+LembarWaktu[[#This Row],[Waktu Pulang]])-LembarWaktu[[#This Row],[Selesai Makan Siang]]+LembarWaktu[[#This Row],[Mulai Makan Siang]]-LembarWaktu[[#This Row],[Waktu Masuk]],IF(AND(LEN(LembarWaktu[[#This Row],[Waktu Masuk]])<>0,LEN(LembarWaktu[[#This Row],[Waktu Pulang]])<>0),(IF(LembarWaktu[[#This Row],[Waktu Pulang]]<LembarWaktu[[#This Row],[Waktu Masuk]],1,0)+LembarWaktu[[#This Row],[Waktu Pulang]])-LembarWaktu[[#This Row],[Waktu Masuk]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Tanggal","Waktu Masuk","Mulai Makan Siang","Selesai Makan Siang","Waktu Pulang",{"$f":"IFERROR(IF(COUNT(LembarWaktu[[#This Row],[Waktu Masuk]:[Waktu Pulang]])=4,(IF(LembarWaktu[[#This Row],[Waktu Pulang]]<LembarWaktu[[#This Row],[Waktu Masuk]],1,0)+LembarWaktu[[#This Row],[Waktu Pulang]])-LembarWaktu[[#This Row],[Selesai Makan Siang]]+LembarWaktu[[#This Row],[Mulai Makan Siang]]-LembarWaktu[[#This Row],[Waktu Masuk]],IF(AND(LEN(LembarWaktu[[#This Row],[Waktu Masuk]])<>0,LEN(LembarWaktu[[#This Row],[Waktu Pulang]])<>0),(IF(LembarWaktu[[#This Row],[Waktu Pulang]]<LembarWaktu[[#This Row],[Waktu Masuk]],1,0)+LembarWaktu[[#This Row],[Waktu Pulang]])-LembarWaktu[[#This Row],[Waktu Masuk]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Tanggal","Waktu Masuk","Mulai Makan Siang","Selesai Makan Siang","Waktu Pulang",{"$f":"IFERROR(IF(COUNT(LembarWaktu[[#This Row],[Waktu Masuk]:[Waktu Pulang]])=4,(IF(LembarWaktu[[#This Row],[Waktu Pulang]]<LembarWaktu[[#This Row],[Waktu Masuk]],1,0)+LembarWaktu[[#This Row],[Waktu Pulang]])-LembarWaktu[[#This Row],[Selesai Makan Siang]]+LembarWaktu[[#This Row],[Mulai Makan Siang]]-LembarWaktu[[#This Row],[Waktu Masuk]],IF(AND(LEN(LembarWaktu[[#This Row],[Waktu Masuk]])<>0,LEN(LembarWaktu[[#This Row],[Waktu Pulang]])<>0),(IF(LembarWaktu[[#This Row],[Waktu Pulang]]<LembarWaktu[[#This Row],[Waktu Masuk]],1,0)+LembarWaktu[[#This Row],[Waktu Pulang]])-LembarWaktu[[#This Row],[Waktu Masuk]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Tanggal","Waktu Masuk","Mulai Makan Siang","Selesai Makan Siang","Waktu Pulang",{"$f":"IFERROR(IF(COUNT(LembarWaktu[[#This Row],[Waktu Masuk]:[Waktu Pulang]])=4,(IF(LembarWaktu[[#This Row],[Waktu Pulang]]<LembarWaktu[[#This Row],[Waktu Masuk]],1,0)+LembarWaktu[[#This Row],[Waktu Pulang]])-LembarWaktu[[#This Row],[Selesai Makan Siang]]+LembarWaktu[[#This Row],[Mulai Makan Siang]]-LembarWaktu[[#This Row],[Waktu Masuk]],IF(AND(LEN(LembarWaktu[[#This Row],[Waktu Masuk]])<>0,LEN(LembarWaktu[[#This Row],[Waktu Pulang]])<>0),(IF(LembarWaktu[[#This Row],[Waktu Pulang]]<LembarWaktu[[#This Row],[Waktu Masuk]],1,0)+LembarWaktu[[#This Row],[Waktu Pulang]])-LembarWaktu[[#This Row],[Waktu Masuk]],0))*24,0)","v":{"v":0,"d":"0.00"}}]