ini sudah saya coba, mudah-mudahan sesuai dengan yang dimaksud. Stepnya gak langsung tapi ada beberapa tahap. Kalau ada yang lebih pas, infoin lagi ya. Ini lagi nyoba2 soalnya.
SalamRian
On Monday, November 30, 2015 4:26 PM, "Salim Jenggot
[email protected] [belajar-excel]" <[email protected]> wrote:
Dear master Kid,
terima kasih banyak atas bantuannya, tetapi beleum sepenuhnya seperti yang saya
maksud.karena yang leadtime seharusnya 14:42 yang terbaca hanya 14 jam
(Seharusnya 15 jam).dalam file yang saya kirim sebelumnya, contoh terdapat
dalam raw D7.
mohon pencerahannya kembali.
terima kasih,SJ
Pada 30 November 2015 14.24, 'Mr. Kid' [email protected] [belajar-excel]
<[email protected]> menulis:
Hai SJ,
Coba :
=IF(IFERROR(B4*C4,0),NETWORKDAYS(B4,C4)&" Hari
"&MAX(1,FLOOR(F4+(F4<E4)-E4,1/24)*24)&" Jam","")
Wassalam,
Kid
2015-11-30 11:05 GMT+07:00 Salim Jenggot [email protected]
[belajar-excel] <[email protected]>:
Dear para master Excel,
mohon bantuannya, apakah ada formula yg lebih simple dari lifetime yg saya
buat.dan untuk cell lifetime yang saya block kuning seharusnya jika hasil
pengurangan jam adalah dibawah/kurang dari 1 jam maka pembulatan menjadi 1 jam.
demikian, mohon ilmunya.
terima kasih,SJ
#yiv9215390777 #yiv9215390777 -- #yiv9215390777ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9215390777
#yiv9215390777ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9215390777
#yiv9215390777ygrp-mkp #yiv9215390777hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9215390777 #yiv9215390777ygrp-mkp #yiv9215390777ads
{margin-bottom:10px;}#yiv9215390777 #yiv9215390777ygrp-mkp .yiv9215390777ad
{padding:0 0;}#yiv9215390777 #yiv9215390777ygrp-mkp .yiv9215390777ad p
{margin:0;}#yiv9215390777 #yiv9215390777ygrp-mkp .yiv9215390777ad a
{color:#0000ff;text-decoration:none;}#yiv9215390777 #yiv9215390777ygrp-sponsor
#yiv9215390777ygrp-lc {font-family:Arial;}#yiv9215390777
#yiv9215390777ygrp-sponsor #yiv9215390777ygrp-lc #yiv9215390777hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9215390777
#yiv9215390777ygrp-sponsor #yiv9215390777ygrp-lc .yiv9215390777ad
{margin-bottom:10px;padding:0 0;}#yiv9215390777 #yiv9215390777actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9215390777
#yiv9215390777activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9215390777
#yiv9215390777activity span {font-weight:700;}#yiv9215390777
#yiv9215390777activity span:first-child
{text-transform:uppercase;}#yiv9215390777 #yiv9215390777activity span a
{color:#5085b6;text-decoration:none;}#yiv9215390777 #yiv9215390777activity span
span {color:#ff7900;}#yiv9215390777 #yiv9215390777activity span
.yiv9215390777underline {text-decoration:underline;}#yiv9215390777
.yiv9215390777attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9215390777 .yiv9215390777attach div a
{text-decoration:none;}#yiv9215390777 .yiv9215390777attach img
{border:none;padding-right:5px;}#yiv9215390777 .yiv9215390777attach label
{display:block;margin-bottom:5px;}#yiv9215390777 .yiv9215390777attach label a
{text-decoration:none;}#yiv9215390777 blockquote {margin:0 0 0
4px;}#yiv9215390777 .yiv9215390777bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9215390777
.yiv9215390777bold a {text-decoration:none;}#yiv9215390777 dd.yiv9215390777last
p a {font-family:Verdana;font-weight:700;}#yiv9215390777 dd.yiv9215390777last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9215390777
dd.yiv9215390777last p span.yiv9215390777yshortcuts
{margin-right:0;}#yiv9215390777 div.yiv9215390777attach-table div div a
{text-decoration:none;}#yiv9215390777 div.yiv9215390777attach-table
{width:400px;}#yiv9215390777 div.yiv9215390777file-title a, #yiv9215390777
div.yiv9215390777file-title a:active, #yiv9215390777
div.yiv9215390777file-title a:hover, #yiv9215390777 div.yiv9215390777file-title
a:visited {text-decoration:none;}#yiv9215390777 div.yiv9215390777photo-title a,
#yiv9215390777 div.yiv9215390777photo-title a:active, #yiv9215390777
div.yiv9215390777photo-title a:hover, #yiv9215390777
div.yiv9215390777photo-title a:visited {text-decoration:none;}#yiv9215390777
div#yiv9215390777ygrp-mlmsg #yiv9215390777ygrp-msg p a
span.yiv9215390777yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9215390777
.yiv9215390777green {color:#628c2a;}#yiv9215390777 .yiv9215390777MsoNormal
{margin:0 0 0 0;}#yiv9215390777 o {font-size:0;}#yiv9215390777
#yiv9215390777photos div {float:left;width:72px;}#yiv9215390777
#yiv9215390777photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9215390777
#yiv9215390777photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9215390777
#yiv9215390777reco-category {font-size:77%;}#yiv9215390777
#yiv9215390777reco-desc {font-size:77%;}#yiv9215390777 .yiv9215390777replbq
{margin:4px;}#yiv9215390777 #yiv9215390777ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9215390777 #yiv9215390777ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9215390777
#yiv9215390777ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9215390777
#yiv9215390777ygrp-mlmsg select, #yiv9215390777 input, #yiv9215390777 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9215390777
#yiv9215390777ygrp-mlmsg pre, #yiv9215390777 code {font:115%
monospace;}#yiv9215390777 #yiv9215390777ygrp-mlmsg *
{line-height:1.22em;}#yiv9215390777 #yiv9215390777ygrp-mlmsg #yiv9215390777logo
{padding-bottom:10px;}#yiv9215390777 #yiv9215390777ygrp-msg p a
{font-family:Verdana;}#yiv9215390777 #yiv9215390777ygrp-msg
p#yiv9215390777attach-count span {color:#1E66AE;font-weight:700;}#yiv9215390777
#yiv9215390777ygrp-reco #yiv9215390777reco-head
{color:#ff7900;font-weight:700;}#yiv9215390777 #yiv9215390777ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9215390777 #yiv9215390777ygrp-sponsor
#yiv9215390777ov li a {font-size:130%;text-decoration:none;}#yiv9215390777
#yiv9215390777ygrp-sponsor #yiv9215390777ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9215390777
#yiv9215390777ygrp-sponsor #yiv9215390777ov ul {margin:0;padding:0 0 0
8px;}#yiv9215390777 #yiv9215390777ygrp-text
{font-family:Georgia;}#yiv9215390777 #yiv9215390777ygrp-text p {margin:0 0 1em
0;}#yiv9215390777 #yiv9215390777ygrp-text tt {font-size:120%;}#yiv9215390777
#yiv9215390777ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9215390777
menghitung Leadtime hari dan jam rian.xlsx
Description: MS-Excel 2007 spreadsheet
