atau =IF(--A6<=$A$4,"Ok","Telat")
wassalam
Ghozi Alkatiri
Pada Kamis, 28 Februari 2019 11.25.30 WIB, Agus [email protected]
[belajar-excel] <[email protected]> menulis:
Wasalamu'alaikum warahmatullah, Dear Eko, bagaimana kalau dikalikan 1 saja!
=IF(A6*1<=$A$4,"Ok","Telat")
wasalam NangAgus
On 2/28/2019 10:20, Wahyu Eko [email protected] [belajar-excel] wrote:
Assalamu'alaikum Wr. Wb
Saya mau minta tolong untuk dibantu untuk solusi permasalahan konversi data
dari fingger Print. Saya mau membuat formula untuk rekap absensi, akan tetapi
daata keluaran dari Fingerprint bentuknya Text sepertinya. MOhon bantuannya..
File Terlampir.
Sebelumnya saya ucapkan terima kasih
Wassalamualaikum, Wr. Wb
#yiv2852062223 #yiv2852062223 -- #yiv2852062223ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2852062223
#yiv2852062223ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2852062223
#yiv2852062223ygrp-mkp #yiv2852062223hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2852062223 #yiv2852062223ygrp-mkp #yiv2852062223ads
{margin-bottom:10px;}#yiv2852062223 #yiv2852062223ygrp-mkp .yiv2852062223ad
{padding:0 0;}#yiv2852062223 #yiv2852062223ygrp-mkp .yiv2852062223ad p
{margin:0;}#yiv2852062223 #yiv2852062223ygrp-mkp .yiv2852062223ad a
{color:#0000ff;text-decoration:none;}#yiv2852062223 #yiv2852062223ygrp-sponsor
#yiv2852062223ygrp-lc {font-family:Arial;}#yiv2852062223
#yiv2852062223ygrp-sponsor #yiv2852062223ygrp-lc #yiv2852062223hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2852062223
#yiv2852062223ygrp-sponsor #yiv2852062223ygrp-lc .yiv2852062223ad
{margin-bottom:10px;padding:0 0;}#yiv2852062223 #yiv2852062223actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2852062223
#yiv2852062223activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2852062223
#yiv2852062223activity span {font-weight:700;}#yiv2852062223
#yiv2852062223activity span:first-child
{text-transform:uppercase;}#yiv2852062223 #yiv2852062223activity span a
{color:#5085b6;text-decoration:none;}#yiv2852062223 #yiv2852062223activity span
span {color:#ff7900;}#yiv2852062223 #yiv2852062223activity span
.yiv2852062223underline {text-decoration:underline;}#yiv2852062223
.yiv2852062223attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2852062223 .yiv2852062223attach div a
{text-decoration:none;}#yiv2852062223 .yiv2852062223attach img
{border:none;padding-right:5px;}#yiv2852062223 .yiv2852062223attach label
{display:block;margin-bottom:5px;}#yiv2852062223 .yiv2852062223attach label a
{text-decoration:none;}#yiv2852062223 blockquote {margin:0 0 0
4px;}#yiv2852062223 .yiv2852062223bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2852062223
.yiv2852062223bold a {text-decoration:none;}#yiv2852062223 dd.yiv2852062223last
p a {font-family:Verdana;font-weight:700;}#yiv2852062223 dd.yiv2852062223last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2852062223
dd.yiv2852062223last p span.yiv2852062223yshortcuts
{margin-right:0;}#yiv2852062223 div.yiv2852062223attach-table div div a
{text-decoration:none;}#yiv2852062223 div.yiv2852062223attach-table
{width:400px;}#yiv2852062223 div.yiv2852062223file-title a, #yiv2852062223
div.yiv2852062223file-title a:active, #yiv2852062223
div.yiv2852062223file-title a:hover, #yiv2852062223 div.yiv2852062223file-title
a:visited {text-decoration:none;}#yiv2852062223 div.yiv2852062223photo-title a,
#yiv2852062223 div.yiv2852062223photo-title a:active, #yiv2852062223
div.yiv2852062223photo-title a:hover, #yiv2852062223
div.yiv2852062223photo-title a:visited {text-decoration:none;}#yiv2852062223
div#yiv2852062223ygrp-mlmsg #yiv2852062223ygrp-msg p a
span.yiv2852062223yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2852062223
.yiv2852062223green {color:#628c2a;}#yiv2852062223 .yiv2852062223MsoNormal
{margin:0 0 0 0;}#yiv2852062223 o {font-size:0;}#yiv2852062223
#yiv2852062223photos div {float:left;width:72px;}#yiv2852062223
#yiv2852062223photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv2852062223
#yiv2852062223photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2852062223
#yiv2852062223reco-category {font-size:77%;}#yiv2852062223
#yiv2852062223reco-desc {font-size:77%;}#yiv2852062223 .yiv2852062223replbq
{margin:4px;}#yiv2852062223 #yiv2852062223ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2852062223 #yiv2852062223ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2852062223
#yiv2852062223ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2852062223
#yiv2852062223ygrp-mlmsg select, #yiv2852062223 input, #yiv2852062223 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2852062223
#yiv2852062223ygrp-mlmsg pre, #yiv2852062223 code {font:115%
monospace;}#yiv2852062223 #yiv2852062223ygrp-mlmsg *
{line-height:1.22em;}#yiv2852062223 #yiv2852062223ygrp-mlmsg #yiv2852062223logo
{padding-bottom:10px;}#yiv2852062223 #yiv2852062223ygrp-msg p a
{font-family:Verdana;}#yiv2852062223 #yiv2852062223ygrp-msg
p#yiv2852062223attach-count span {color:#1E66AE;font-weight:700;}#yiv2852062223
#yiv2852062223ygrp-reco #yiv2852062223reco-head
{color:#ff7900;font-weight:700;}#yiv2852062223 #yiv2852062223ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2852062223 #yiv2852062223ygrp-sponsor
#yiv2852062223ov li a {font-size:130%;text-decoration:none;}#yiv2852062223
#yiv2852062223ygrp-sponsor #yiv2852062223ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2852062223
#yiv2852062223ygrp-sponsor #yiv2852062223ov ul {margin:0;padding:0 0 0
8px;}#yiv2852062223 #yiv2852062223ygrp-text
{font-family:Georgia;}#yiv2852062223 #yiv2852062223ygrp-text p {margin:0 0 1em
0;}#yiv2852062223 #yiv2852062223ygrp-text tt {font-size:120%;}#yiv2852062223
#yiv2852062223ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2852062223
