---Posted by Terry Kreft--- -------------------------------------------------------------------------------- Date/Time: Calculate differences in time --------------------------------------------------------------------------------
You can use the following logic to calculate the difference between two times which works even across midnight. Format([StartTime] -1 -[EndTime], "Short Time") =========================================================== --- Rosana Dewi <[EMAIL PROTECTED]> wrote: > Temen2 pakar, > > Mohon bantuannya gimana caranya saya mengitung jam > dari dua field yang > berisi format tanggal misalnya > > DateIn dan DateOut > > Value dari field diatas diisi dengan format now() > dengan menekan > command button yang saya sudah bikin > > Misalnya DateIn 20/04/2008 DateOut 29/04/2008 > > Berapa jam kah waktu antara kedua tanggal tersebut > dalam format hh:mm:ss > > > > Salam > Dewi > ___________________________________________________________________________ Joint with us, you will earn some cash when you make some disscusion http://www.mylot.com/?ref=darsono72 ___________________________________________________________________________ Atau yang ini saya yakin anda tertarik http://www.UangGampang.Com/?id=darsono72 ___________________________________________________________________________ ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
