menu "format cell", pilih "custom", pilih yang type [h]:mm:ss semoga membantu...
________________________________________ From: [email protected] [[email protected]] On Behalf Of dodi handika [[email protected]] Sent: Saturday, April 11, 2009 4:11 PM To: [email protected] Subject: ]] XL-mania [[ cara menjumlah waktu (jam) dear exelwan & exelwati, mohon bantuannya, bagaimana yah caranya "menjumlah waktu (jam) yang berformat "hour" dengan rumus. karena sudah saya coba, tapi belum ketemu juga rumusnya. contohnya seperti ini : 08:00 jam (format "hour") 08:15 jam 08:30 jam -------------- jumlah: 24:45 jam (format "hour") mohon masukan dari para suhu.. terima kasih sebelumnya.. "This e-mail (including any attachments) is intended solely for the addressee and could contain information that is confidential; If you are not the intended recipient, you are hereby notified that any use, disclosure, copying or dissemination of this e-mail and any attachment is strictly prohibited and you should immediately delete it. This message does not necessarily reflect the views of Bank Indonesia. Although this e-mail has been checked for computer viruses, Bank Indonesia accepts no liability for any damage caused by any virus and any malicious code transmitted by this e-mail. Therefore, the recipient should check again for the risk of viruses, malicious codes, etc as a result of e-mail transmission through Internet."
