Alhamdulillah, Ok formulanya Mr. Kid, Jazakumulloh Ahsana Jaza..

Terima Kasih

Matzen

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 14 Mei 2014 10:19
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Menghitung different jam



Coba:
=selesai-mulai+(selesai<mulai)

Wassalam
Kid
On May 14, 2014 9:45 AM, "'Subroto, Matzen' 
matzen.subr...@akzonobel.com<mailto:matzen.subr...@akzonobel.com> 
[belajar-excel]" 
<belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>> wrote:

Dear Master,

Saya punya data jam mulai dan jam selesai, saya kesulitan menghitung ketika jam 
selesai nya tepat jam 00:00:00 atau lebih


Terima Kasih

Matzen



____________________________________________________________________________
This email has been scanned for Viruses and Spam. For more information
please contact your local Business Unit Information Security representative.
____________________________________________________________________________
  • [belajar-ex... 'Subroto, Matzen' matzen.subr...@akzonobel.com [belajar-excel]
    • Bls: [... 'odongna...@yahoo.com' odongna...@yahoo.com [belajar-excel]
      • RE... 'Subroto, Matzen' matzen.subr...@akzonobel.com [belajar-excel]
    • Re: [b... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
      • RE... 'Subroto, Matzen' matzen.subr...@akzonobel.com [belajar-excel]
    • Re: RE... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
      • Bl... odong nando odongna...@yahoo.com [belajar-excel]
        • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]

Kirim email ke