pake rumus ini pak, =ROUND( C4+E4+((B4+D4)>(D4+E4))*"12:00:00"-B4-D4,6) saya dapat dari mr . Kid dulu kalau gak salah
Best Regards,
Fajar Fatahillah
On Wednesday, June 3, 2015 1:58 PM, "egidia seftyanaputri
[email protected] [belajar-excel]" <[email protected]> wrote:
Dear pak Matzen,
mungkin formulanya seperti ini:
= ( Tanggal_Finish + Waktu_Finish ) - ( Tanggal_Start + Waktu_Start)
maaf, tidak bisa melampirkan file excel-nya.
cmiiw,
Regards,
-putri-
Pada 3 Juni 2015 12.53, 'Subroto, Matzen' [email protected]
[belajar-excel] <[email protected]> menulis:
Dear master Semoga semua selalu dalam Limpahan Berkah dan Hidayah NyaMohon
tambahan ilmunya, dengan kasus yang saya dapati, yaitu menghitung Durasi waktu
dengan hari yang berbeda seperti file terlampir Terima kasih atas perhatian
dan kerjasamanya, dan saya mohon maaf apabila ada kata-kata yang kurang
berkenan Terima Kasih Matzen
#yiv6333063012 #yiv6333063012 -- #yiv6333063012ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6333063012
#yiv6333063012ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6333063012
#yiv6333063012ygrp-mkp #yiv6333063012hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6333063012 #yiv6333063012ygrp-mkp #yiv6333063012ads
{margin-bottom:10px;}#yiv6333063012 #yiv6333063012ygrp-mkp .yiv6333063012ad
{padding:0 0;}#yiv6333063012 #yiv6333063012ygrp-mkp .yiv6333063012ad p
{margin:0;}#yiv6333063012 #yiv6333063012ygrp-mkp .yiv6333063012ad a
{color:#0000ff;text-decoration:none;}#yiv6333063012 #yiv6333063012ygrp-sponsor
#yiv6333063012ygrp-lc {font-family:Arial;}#yiv6333063012
#yiv6333063012ygrp-sponsor #yiv6333063012ygrp-lc #yiv6333063012hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6333063012
#yiv6333063012ygrp-sponsor #yiv6333063012ygrp-lc .yiv6333063012ad
{margin-bottom:10px;padding:0 0;}#yiv6333063012 #yiv6333063012actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6333063012
#yiv6333063012activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6333063012
#yiv6333063012activity span {font-weight:700;}#yiv6333063012
#yiv6333063012activity span:first-child
{text-transform:uppercase;}#yiv6333063012 #yiv6333063012activity span a
{color:#5085b6;text-decoration:none;}#yiv6333063012 #yiv6333063012activity span
span {color:#ff7900;}#yiv6333063012 #yiv6333063012activity span
.yiv6333063012underline {text-decoration:underline;}#yiv6333063012
.yiv6333063012attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6333063012 .yiv6333063012attach div a
{text-decoration:none;}#yiv6333063012 .yiv6333063012attach img
{border:none;padding-right:5px;}#yiv6333063012 .yiv6333063012attach label
{display:block;margin-bottom:5px;}#yiv6333063012 .yiv6333063012attach label a
{text-decoration:none;}#yiv6333063012 blockquote {margin:0 0 0
4px;}#yiv6333063012 .yiv6333063012bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6333063012
.yiv6333063012bold a {text-decoration:none;}#yiv6333063012 dd.yiv6333063012last
p a {font-family:Verdana;font-weight:700;}#yiv6333063012 dd.yiv6333063012last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6333063012
dd.yiv6333063012last p span.yiv6333063012yshortcuts
{margin-right:0;}#yiv6333063012 div.yiv6333063012attach-table div div a
{text-decoration:none;}#yiv6333063012 div.yiv6333063012attach-table
{width:400px;}#yiv6333063012 div.yiv6333063012file-title a, #yiv6333063012
div.yiv6333063012file-title a:active, #yiv6333063012
div.yiv6333063012file-title a:hover, #yiv6333063012 div.yiv6333063012file-title
a:visited {text-decoration:none;}#yiv6333063012 div.yiv6333063012photo-title a,
#yiv6333063012 div.yiv6333063012photo-title a:active, #yiv6333063012
div.yiv6333063012photo-title a:hover, #yiv6333063012
div.yiv6333063012photo-title a:visited {text-decoration:none;}#yiv6333063012
div#yiv6333063012ygrp-mlmsg #yiv6333063012ygrp-msg p a
span.yiv6333063012yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6333063012
.yiv6333063012green {color:#628c2a;}#yiv6333063012 .yiv6333063012MsoNormal
{margin:0 0 0 0;}#yiv6333063012 o {font-size:0;}#yiv6333063012
#yiv6333063012photos div {float:left;width:72px;}#yiv6333063012
#yiv6333063012photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6333063012
#yiv6333063012photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6333063012
#yiv6333063012reco-category {font-size:77%;}#yiv6333063012
#yiv6333063012reco-desc {font-size:77%;}#yiv6333063012 .yiv6333063012replbq
{margin:4px;}#yiv6333063012 #yiv6333063012ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6333063012 #yiv6333063012ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6333063012
#yiv6333063012ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6333063012
#yiv6333063012ygrp-mlmsg select, #yiv6333063012 input, #yiv6333063012 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6333063012
#yiv6333063012ygrp-mlmsg pre, #yiv6333063012 code {font:115%
monospace;}#yiv6333063012 #yiv6333063012ygrp-mlmsg *
{line-height:1.22em;}#yiv6333063012 #yiv6333063012ygrp-mlmsg #yiv6333063012logo
{padding-bottom:10px;}#yiv6333063012 #yiv6333063012ygrp-msg p a
{font-family:Verdana;}#yiv6333063012 #yiv6333063012ygrp-msg
p#yiv6333063012attach-count span {color:#1E66AE;font-weight:700;}#yiv6333063012
#yiv6333063012ygrp-reco #yiv6333063012reco-head
{color:#ff7900;font-weight:700;}#yiv6333063012 #yiv6333063012ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6333063012 #yiv6333063012ygrp-sponsor
#yiv6333063012ov li a {font-size:130%;text-decoration:none;}#yiv6333063012
#yiv6333063012ygrp-sponsor #yiv6333063012ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6333063012
#yiv6333063012ygrp-sponsor #yiv6333063012ov ul {margin:0;padding:0 0 0
8px;}#yiv6333063012 #yiv6333063012ygrp-text
{font-family:Georgia;}#yiv6333063012 #yiv6333063012ygrp-text p {margin:0 0 1em
0;}#yiv6333063012 #yiv6333063012ygrp-text tt {font-size:120%;}#yiv6333063012
#yiv6333063012ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6333063012
Durasi.xlsx
Description: MS-Excel 2007 spreadsheet
