Dear Ahmad, Kalau aku lihat sekilas.. untuk yang A, secara rumus sudah oke... cuma satu... yang buat hasilnya jadi nol.....
nama A di ke dua sheet tidak sama.... (ada spasi di sheet data , sedangkan di sheet view itu tidak ada spasi) note : spasi = spacebar mudah-mudahan sesuai dengan yang diinginkan. 2009/12/21 Ahmad <[email protected]>: > Assalamualaikum wrt.. > > Apa khbr sahabat2 excel sekalian... > > saya ingin meminta bantuan bagi menyelesaikan masalah sy. > > Bagaimana saya nak mengira jumlah hours bagi seseorg mengikut jenis time off > di Sheet DATA. > Saya dah cuba menggunakan sumproduct, tapi x dapat kerana sy x tau formula > untuk mengira time. > Ataupun sahabat2 ada cara yg lebih baik. > Harap Sahabat2 sekalian dapat membantu saya... > > Terima Kasih > Ahmad > /---------------------------------------------------------------------------\ > > Confidential and/ or privileged information may be contained in this > e-mail and any attachments transmitted with it ('Message'). If you are > not the addressee indicated in this Message (or responsible for > delivery of this Message to such person),you are hereby notified that > any dissemination, distribution, printing or copying of this Message or > any part thereof is prohibited. Please delete this Message if received > in error and advise the sender by return e-mail. Opinions, conclusions > and other information in this Message that do not relate to the > official business of this company shall be understood as neither given > nor endorsed by this company. > > This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) > *Scanner Engine powered by Norman Virus Control > > \--------------------------------------------------------------------------/ > > -- Terima kasih Raya
Copy of mengira jumlah masa mengikut nama.xls
Description: MS-Excel spreadsheet
