Dear Bpk Tobby Terima kasih untuk bantuan yang sudah anda berikan, tetapi saya masih bingung, karenaada yang tidak sesuai dengan harapan. Saya berikan dalam sebuah file terlampir, untuk menjelaskanperihal tersebut. Salam Hangat
Tjahya
Pada Minggu, 7 Juni 2015 19:00, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> menulis:
| Dear pak Tjahya,Mungkin file ini bisa membantu.TerimaKasih.Sent from Yahoo
Mail on Android |
From: Tjahya Hartono [email protected] [belajar-excel]
<[email protected]>;
To: <[email protected]>;
Subject: [belajar-excel] Cara hitung lembur [1 Attachment]
Sent: Fri, Jun 5, 2015 8:25:52 AM
| Dear Be Excel,Bagaimanacaranya ya mengisi lembur dari input absen,
tetapi hasilnya langsung dimasukkanlangsung kedalam cell G8. Berikut saya
lampirkan datanya dibawah.Terimakasih
SalamHangat
Tjahya
|
#yiv7601037304 #yiv7601037304 -- #yiv7601037304ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7601037304
#yiv7601037304ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7601037304
#yiv7601037304ygrp-mkp #yiv7601037304hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7601037304 #yiv7601037304ygrp-mkp #yiv7601037304ads
{margin-bottom:10px;}#yiv7601037304 #yiv7601037304ygrp-mkp .yiv7601037304ad
{padding:0 0;}#yiv7601037304 #yiv7601037304ygrp-mkp .yiv7601037304ad p
{margin:0;}#yiv7601037304 #yiv7601037304ygrp-mkp .yiv7601037304ad a
{color:#0000ff;text-decoration:none;}#yiv7601037304 #yiv7601037304ygrp-sponsor
#yiv7601037304ygrp-lc {font-family:Arial;}#yiv7601037304
#yiv7601037304ygrp-sponsor #yiv7601037304ygrp-lc #yiv7601037304hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7601037304
#yiv7601037304ygrp-sponsor #yiv7601037304ygrp-lc .yiv7601037304ad
{margin-bottom:10px;padding:0 0;}#yiv7601037304 #yiv7601037304actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7601037304
#yiv7601037304activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7601037304
#yiv7601037304activity span {font-weight:700;}#yiv7601037304
#yiv7601037304activity span:first-child
{text-transform:uppercase;}#yiv7601037304 #yiv7601037304activity span a
{color:#5085b6;text-decoration:none;}#yiv7601037304 #yiv7601037304activity span
span {color:#ff7900;}#yiv7601037304 #yiv7601037304activity span
.yiv7601037304underline {text-decoration:underline;}#yiv7601037304
.yiv7601037304attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7601037304 .yiv7601037304attach div a
{text-decoration:none;}#yiv7601037304 .yiv7601037304attach img
{border:none;padding-right:5px;}#yiv7601037304 .yiv7601037304attach label
{display:block;margin-bottom:5px;}#yiv7601037304 .yiv7601037304attach label a
{text-decoration:none;}#yiv7601037304 blockquote {margin:0 0 0
4px;}#yiv7601037304 .yiv7601037304bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7601037304
.yiv7601037304bold a {text-decoration:none;}#yiv7601037304 dd.yiv7601037304last
p a {font-family:Verdana;font-weight:700;}#yiv7601037304 dd.yiv7601037304last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7601037304
dd.yiv7601037304last p span.yiv7601037304yshortcuts
{margin-right:0;}#yiv7601037304 div.yiv7601037304attach-table div div a
{text-decoration:none;}#yiv7601037304 div.yiv7601037304attach-table
{width:400px;}#yiv7601037304 div.yiv7601037304file-title a, #yiv7601037304
div.yiv7601037304file-title a:active, #yiv7601037304
div.yiv7601037304file-title a:hover, #yiv7601037304 div.yiv7601037304file-title
a:visited {text-decoration:none;}#yiv7601037304 div.yiv7601037304photo-title a,
#yiv7601037304 div.yiv7601037304photo-title a:active, #yiv7601037304
div.yiv7601037304photo-title a:hover, #yiv7601037304
div.yiv7601037304photo-title a:visited {text-decoration:none;}#yiv7601037304
div#yiv7601037304ygrp-mlmsg #yiv7601037304ygrp-msg p a
span.yiv7601037304yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7601037304
.yiv7601037304green {color:#628c2a;}#yiv7601037304 .yiv7601037304MsoNormal
{margin:0 0 0 0;}#yiv7601037304 o {font-size:0;}#yiv7601037304
#yiv7601037304photos div {float:left;width:72px;}#yiv7601037304
#yiv7601037304photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7601037304
#yiv7601037304photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7601037304
#yiv7601037304reco-category {font-size:77%;}#yiv7601037304
#yiv7601037304reco-desc {font-size:77%;}#yiv7601037304 .yiv7601037304replbq
{margin:4px;}#yiv7601037304 #yiv7601037304ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7601037304 #yiv7601037304ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7601037304
#yiv7601037304ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7601037304
#yiv7601037304ygrp-mlmsg select, #yiv7601037304 input, #yiv7601037304 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7601037304
#yiv7601037304ygrp-mlmsg pre, #yiv7601037304 code {font:115%
monospace;}#yiv7601037304 #yiv7601037304ygrp-mlmsg *
{line-height:1.22em;}#yiv7601037304 #yiv7601037304ygrp-mlmsg #yiv7601037304logo
{padding-bottom:10px;}#yiv7601037304 #yiv7601037304ygrp-msg p a
{font-family:Verdana;}#yiv7601037304 #yiv7601037304ygrp-msg
p#yiv7601037304attach-count span {color:#1E66AE;font-weight:700;}#yiv7601037304
#yiv7601037304ygrp-reco #yiv7601037304reco-head
{color:#ff7900;font-weight:700;}#yiv7601037304 #yiv7601037304ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7601037304 #yiv7601037304ygrp-sponsor
#yiv7601037304ov li a {font-size:130%;text-decoration:none;}#yiv7601037304
#yiv7601037304ygrp-sponsor #yiv7601037304ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7601037304
#yiv7601037304ygrp-sponsor #yiv7601037304ov ul {margin:0;padding:0 0 0
8px;}#yiv7601037304 #yiv7601037304ygrp-text
{font-family:Georgia;}#yiv7601037304 #yiv7601037304ygrp-text p {margin:0 0 1em
0;}#yiv7601037304 #yiv7601037304ygrp-text tt {font-size:120%;}#yiv7601037304
#yiv7601037304ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7601037304
hitung lembur_toby.xlsx
Description: MS-Excel 2007 spreadsheet
