pak sis coba file terlampir semoga sesuai salamlb
Pada Kamis, 2 April 2015 9:50, "harry siswanto hsiswa...@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear senior,mohon bantuannya,saya ada problem untuk menghitung jam kerja
dalam worksheet di Excel,(terlampir filenya)
1. Bagaimana menghitung jumlah jam kerja pada cell di Excel, bila dimasukan
tanda "X" pada Cellnya.?diharapkan pada kolom Workhours otomatis terhitung jam
kerja.2. pada sheet Alternatif lain, bagaimana rumusannya, bila cara mengisinya
dengan memberi tanda centang pada tiap cellnya.3. sistematika kerjanya memang
masih sederhana dan manual, apa ada Modeling lain yang mungkin lebih mudah dan
user friendly?
terimakasih sebelumnya.
Regards
Harry Siswanto #yiv2162545213 -- #yiv2162545213ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2162545213
#yiv2162545213ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2162545213
#yiv2162545213ygrp-mkp #yiv2162545213hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2162545213 #yiv2162545213ygrp-mkp #yiv2162545213ads
{margin-bottom:10px;}#yiv2162545213 #yiv2162545213ygrp-mkp .yiv2162545213ad
{padding:0 0;}#yiv2162545213 #yiv2162545213ygrp-mkp .yiv2162545213ad p
{margin:0;}#yiv2162545213 #yiv2162545213ygrp-mkp .yiv2162545213ad a
{color:#0000ff;text-decoration:none;}#yiv2162545213 #yiv2162545213ygrp-sponsor
#yiv2162545213ygrp-lc {font-family:Arial;}#yiv2162545213
#yiv2162545213ygrp-sponsor #yiv2162545213ygrp-lc #yiv2162545213hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2162545213
#yiv2162545213ygrp-sponsor #yiv2162545213ygrp-lc .yiv2162545213ad
{margin-bottom:10px;padding:0 0;}#yiv2162545213 #yiv2162545213actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2162545213
#yiv2162545213activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2162545213
#yiv2162545213activity span {font-weight:700;}#yiv2162545213
#yiv2162545213activity span:first-child
{text-transform:uppercase;}#yiv2162545213 #yiv2162545213activity span a
{color:#5085b6;text-decoration:none;}#yiv2162545213 #yiv2162545213activity span
span {color:#ff7900;}#yiv2162545213 #yiv2162545213activity span
.yiv2162545213underline {text-decoration:underline;}#yiv2162545213
.yiv2162545213attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2162545213 .yiv2162545213attach div a
{text-decoration:none;}#yiv2162545213 .yiv2162545213attach img
{border:none;padding-right:5px;}#yiv2162545213 .yiv2162545213attach label
{display:block;margin-bottom:5px;}#yiv2162545213 .yiv2162545213attach label a
{text-decoration:none;}#yiv2162545213 blockquote {margin:0 0 0
4px;}#yiv2162545213 .yiv2162545213bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2162545213
.yiv2162545213bold a {text-decoration:none;}#yiv2162545213 dd.yiv2162545213last
p a {font-family:Verdana;font-weight:700;}#yiv2162545213 dd.yiv2162545213last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2162545213
dd.yiv2162545213last p span.yiv2162545213yshortcuts
{margin-right:0;}#yiv2162545213 div.yiv2162545213attach-table div div a
{text-decoration:none;}#yiv2162545213 div.yiv2162545213attach-table
{width:400px;}#yiv2162545213 div.yiv2162545213file-title a, #yiv2162545213
div.yiv2162545213file-title a:active, #yiv2162545213
div.yiv2162545213file-title a:hover, #yiv2162545213 div.yiv2162545213file-title
a:visited {text-decoration:none;}#yiv2162545213 div.yiv2162545213photo-title a,
#yiv2162545213 div.yiv2162545213photo-title a:active, #yiv2162545213
div.yiv2162545213photo-title a:hover, #yiv2162545213
div.yiv2162545213photo-title a:visited {text-decoration:none;}#yiv2162545213
div#yiv2162545213ygrp-mlmsg #yiv2162545213ygrp-msg p a
span.yiv2162545213yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2162545213
.yiv2162545213green {color:#628c2a;}#yiv2162545213 .yiv2162545213MsoNormal
{margin:0 0 0 0;}#yiv2162545213 o {font-size:0;}#yiv2162545213
#yiv2162545213photos div {float:left;width:72px;}#yiv2162545213
#yiv2162545213photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2162545213
#yiv2162545213photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2162545213
#yiv2162545213reco-category {font-size:77%;}#yiv2162545213
#yiv2162545213reco-desc {font-size:77%;}#yiv2162545213 .yiv2162545213replbq
{margin:4px;}#yiv2162545213 #yiv2162545213ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2162545213 #yiv2162545213ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2162545213
#yiv2162545213ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2162545213
#yiv2162545213ygrp-mlmsg select, #yiv2162545213 input, #yiv2162545213 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2162545213
#yiv2162545213ygrp-mlmsg pre, #yiv2162545213 code {font:115%
monospace;}#yiv2162545213 #yiv2162545213ygrp-mlmsg *
{line-height:1.22em;}#yiv2162545213 #yiv2162545213ygrp-mlmsg #yiv2162545213logo
{padding-bottom:10px;}#yiv2162545213 #yiv2162545213ygrp-msg p a
{font-family:Verdana;}#yiv2162545213 #yiv2162545213ygrp-msg
p#yiv2162545213attach-count span {color:#1E66AE;font-weight:700;}#yiv2162545213
#yiv2162545213ygrp-reco #yiv2162545213reco-head
{color:#ff7900;font-weight:700;}#yiv2162545213 #yiv2162545213ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2162545213 #yiv2162545213ygrp-sponsor
#yiv2162545213ov li a {font-size:130%;text-decoration:none;}#yiv2162545213
#yiv2162545213ygrp-sponsor #yiv2162545213ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2162545213
#yiv2162545213ygrp-sponsor #yiv2162545213ov ul {margin:0;padding:0 0 0
8px;}#yiv2162545213 #yiv2162545213ygrp-text
{font-family:Georgia;}#yiv2162545213 #yiv2162545213ygrp-text p {margin:0 0 1em
0;}#yiv2162545213 #yiv2162545213ygrp-text tt {font-size:120%;}#yiv2162545213
#yiv2162545213ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2162545213
RE-Kasus_Excel.xlsx
Description: MS-Excel 2007 spreadsheet
