Sdr Thio Agustinus, yth.
input jam1S 'format 99:99:99
input jam2S
jam1N=val(mid$(jam1S,1,2)) 'asumsi huruf pertama di posisi ke-1
menit1N=val(mid$(jam1S,4,2))
detik1N=val(mid$(jam1S,7,2))+menit1N*60+jam1N*3600
jam2N=val(mid$(jam2S,1,2))
menit2N=val(mid$(jam2S,4,2))
detik2N=val(mid$(jam2S,7,2))+menit2N*60+jam2N*3600+detik1N
jam3N=int(detik2N/3600)
menit3N=int((detik2N mod 3600)/60)
detik3N=(detik2N mod 3600) mod 60
return str$(jam3N)+":"+str$(menit3N)+":"+str$(detik3N)
Semoga membantu,
Handoko (yuhana dot com)
----- Original Message -----
From: Thio Agustinus
To: ITCENTER@yahoogroups.com
Sent: Monday, October 08, 2007 11:13 AM
Subject: RE: [ITCENTER] VB Help Me !!! menjumlahkan jam di acces atau vb
yang dsimpan di database
Ubah jadi detik. jumlahkan, ubah kembali jadi jam, menit, detik.
SOL
udah gw coba pake script diatas, ternyata jumlah jamnya ngaco...
yang ter jumlah cuma jamnya aja, menitnya ga kejumlah....
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
