RE: [Programmer-VB] ngitung jam di Ms. Excel

[Antonius Pungkas]

Iya… betul mas… dikurangi aja, asal tipenya dalam bentuk date kalo ga salah, dia bisa dikurangi… J                         ,,,                     (o o) ------------oOOo-(_)-oOOo------------   Pungki From: Programmer-VB@yahoogroups.com [mailto:Programmer-VB@yahoogroups.com] On Behalf Of thoyib Sent: Thursday, February 16, 2006 4:56 PM To: Programmer-VB@yahoogroups.com Subject: Re: [Programmer-VB] ngitung jam di Ms. Excel   Sebelumnya trima kasih atas pencerahannya, tapi yg saya mo tanya bagaimanna formula di Ms. Excelnya.. ----- Original Message ----- From: Purwedi Kurniawan To: Programmer-VB@yahoogroups.com Sent: Thursday, February 16, 2006 4:24 PM Subject: Re: [Programmer-VB] ngitung jam di Ms. Excel   dikurangi aja mas :) kalau data yg di input seperti kolom 1&2 berikut, dia otomatis dianggap jam kok (h:mm). kolom ke 3 hasil pengurangan kolom 2 - kolom 1.   11:00 12:00 1:00 11:00 13:00 2:00 11:00 13:25 2:25 11:00 13:45 2:45 best regards [wwn]   On 2/16/06, thoyib <[EMAIL PROTECTED]> wrote: Sebelumnya maap kalo saya nanya rumus excel di forum ini. Mungkin rekan2 ada yg mo bantu, saya punya problem nich, gimana caranya menghitung jam akhir - jam awal ?   Contoh kasus:   Actual Start                Actual Finish            Jumlah Jam 11:00                        12:00                        1 11:00                        13:00                        2   Mohon bantuannya bagaimana cara menghitung jumlah jam tsb di Ms. Excell..?     Salam,   Thoy Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut:     http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke:     [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini:     Yahoo! Messenger: wahanaprogrammer SPONSORED LINKS Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language   YAHOO! GROUPS LINKS    Visit your group "Programmer-VB" on the web.    To unsubscribe from this group, send an email to:   [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.     No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.9/261 - Release Date: 2/15/2006 Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut:     http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke:     [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini:     Yahoo! Messenger: wahanaprogrammer SPONSORED LINKS Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language YAHOO! GROUPS LINKS  Visit your group "Programmer-VB" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.