rumus lembur

LemburDAFTAR UPAH LEMBUR KARYAWANNAMA KARYAWANBUDI SAJAPeriode Lembur:OctobersampaiNovemberNIK123456UMK1,188,435N0Libur/Libur/JML JAMNILAI JAM KERJATOTALTGLKerjaKerjaKERJAABCDJAMABCDTOTALLEMBUR1.5234LEMBUR1Saturday, 15-Oct-2011KLKLL303006.0- 041,217- 0- 041,217KLL2Sunday, 16-Oct-2011LKLKL303006.0- 041,217- 0- 041,217LKL3Monday, 17-Oct-2011KKKKK211000.010,30413,739- 0- 024,043KKK4Tuesday, 18-Oct-2011KKKKK211003.510,30413,739- 0- 024,0435Wednesday, 19-Oct-2011KKKKK211003.510,30413,739- 0- 024,0436Thursday, 20-Oct-2011KKKKK9180017.510,304109,913- 0- 0120,2177Friday, 21-Oct-2011KKKKK10190019.510,304123,652- 0- 0133,9578Saturday, 22-Oct-2011KLKLL202004.0- 027,478- 0- 027,4789Sunday, 23-Oct-2011LKLKL10071225.0- 096,17420,60954,957171,73910Monday, 24-Oct-2011KKKKK211003.510,30413,739- 0- 024,04311Tuesday, 25-Oct-2011KKKKK312005.510,30427,478- 0- 037,78312Wednesday, 26-Oct-2011KKKKK211003.510,30413,739- 0- 024,04313Thursday, 27-Oct-2011KKKKK110001.510,304- 0- 0- 010,30414Friday, 28-Oct-2011KKKKK211003.510,30413,739- 0- 024,04315Saturday, 29-Oct-2011KLKLL303006.0- 041,217- 0- 041,21716Sunday, 30-Oct-2011LKLKL101002.0- 013,739- 0- 013,73917Monday, 31-Oct-2011KKKKK110001.510,304- 0- 0- 010,30418Tuesday, 01-Nov-2011KKKKK110001.510,304- 0- 0- 010,30419Wednesday, 02-Nov-2011KKKKK312005.510,30427,478- 0- 037,78320Thursday, 03-Nov-2011KKKKK312005.510,30427,478- 0- 037,78321Friday, 04-Nov-2011KKKKK211003.510,30413,739- 0- 024,04322Saturday, 05-Nov-2011KLKLL202004.0- 027,478- 0- 027,47823Sunday, 06-Nov-2011LKLKL202004.0- 027,478- 0- 027,47824Monday, 07-Nov-2011KKKKK110001.510,304- 0- 0- 010,30425Tuesday, 08-Nov-2011KKKKK110001.510,304- 0- 0- 010,30426Wednesday, 09-Nov-2011KKKKK211003.510,30413,739- 0- 024,04327Thursday, 10-Nov-2011KKKKK211003.510,30413,739- 0- 024,04328Friday, 11-Nov-2011KKKKK211003.510,30413,739- 0- 024,04329Saturday, 12-Nov-2011KLKLL202004.0- 027,478- 0- 027,47830Sunday, 13-Nov-2011LKLKL303006.0- 041,217- 0- 041,21731Monday, 14-Nov-2011KKKKK110001.510,304- 0- 0- 010,30411/14/111,130,044

Attribute VB_Name = "ThisWorkbook"Attribute VB_Base = "0{00020819-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True

Attribute VB_Name = "Sheet3"Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = TruePrivate Sub CommandButton1_Click() UserForm1.ShowEnd Sub