Ups… Salah

 

[AT8] 
=SUM(IF((M8-7)>1,1,IF((M8-7)>0,M8-7,0)),IF((AA8-7)>1,1,IF((AA8-7)>0,AA8-7,0)))

 

CMIIW

Salam Hangat dan Jabat Erat

From: [email protected] [mailto:[email protected]] On 
Behalf Of Wahyudi, Hery UTAS
Sent: Monday, September 10, 2012 3:58 PM
To: [email protected]
Subject: RE: [belajar-excel] menghitung lembur hari libur

 

  

[AT8]=SUM(AA8,M8)-AS8

 

CMIIW

 

From: [email protected] [mailto:[email protected]] On 
Behalf Of indria pie
Sent: Monday, September 10, 2012 3:31 PM
To: [email protected]
Subject: [belajar-excel] menghitung lembur hari libur

 

  

dear Suhu Excel

 

saya punya permasalahan dalam menghitung lembur hari libur seperti file 
terlampir, mohon bantuannya

formula apa yang harus saya gunakan untuk isi cell AT8 (lembur "L2")

 

trims

 

-snupy-



Kirim email ke