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
\--------------------------------------------------------------------------/
mengira jumlah masa mengikut nama.xls
Description: MS-Excel spreadsheet
