mudah2an sesuai dengan yang dimaksud

jika jam operasional 24 jam/hari
=((C7+D7)-(A7+B7))*24&" Jam"

jika jam operasional 8 jam/hari
=(C7-A7)*8+((D7-B7)*24)&" Jam"

untuk satuan menit atau jam operasional berbeda tinggal disesuaikan :)

salam,
Deni

On 4/16/2014 9:14 AM, MSJ Planners Block D wrote:
>
> Team,,
>
> Bias dibantu… lagi blank sudah. Terim’s
>
> Salam,
>
> Musriadi
>
>
> ______________________________________________________________________
> This email has been scanned by the Symantec Email Security.cloud service.
> For more information please visit http://www.symanteccloud.com
> ______________________________________________________________________
> 

Kirim email ke