Jozz.....makasih banyak ya ....
"Arigatou gozaimasu"
Luddy Subiyandoko
Pada Selasa, 3 Maret 2015 9:02, "luddy subiyandoko
luddy_subiyand...@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:
Tx a lot bro...luar biasa membantu..
tapi kalau misalnya dikunci jam 11 siang apa yang dirubah ya??
"Arigatou gozaimasu"
Luddy Subiyandoko
Pada Selasa, 3 Maret 2015 7:51, "Nang Agus nanga...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Seperti inikah?
=AND(NOW()<=$B7+34/24,NOW()>=$B7)
2015-03-02 12:35 GMT+07:00 luddy subiyandoko luddy_subiyand...@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com>:
Dear All Mohon pencerahannya ya master2 untuk masalah yangmembelenggu saya;Saya
mengalami kesulitan dalam membatasi penginputanberdasarkan tanggal dan
waktu.saya ingin membuat dimana cell akan terkunci setelah tanggalitu berlalu
sehingga apabila tanggal dan waktu yang ditetapkan melebihi batascell tidak
bisa diinput atau revisi untuk jelasnya file terlampir Mohon bantuannya dengan
sangat ya master "Arigatou gozaimasu"
Luddy Subiyandoko
#yiv4750670380 #yiv4750670380 -- #yiv4750670380ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4750670380
#yiv4750670380ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4750670380
#yiv4750670380ygrp-mkp #yiv4750670380hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4750670380 #yiv4750670380ygrp-mkp #yiv4750670380ads
{margin-bottom:10px;}#yiv4750670380 #yiv4750670380ygrp-mkp .yiv4750670380ad
{padding:0 0;}#yiv4750670380 #yiv4750670380ygrp-mkp .yiv4750670380ad p
{margin:0;}#yiv4750670380 #yiv4750670380ygrp-mkp .yiv4750670380ad a
{color:#0000ff;text-decoration:none;}#yiv4750670380 #yiv4750670380ygrp-sponsor
#yiv4750670380ygrp-lc {font-family:Arial;}#yiv4750670380
#yiv4750670380ygrp-sponsor #yiv4750670380ygrp-lc #yiv4750670380hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4750670380
#yiv4750670380ygrp-sponsor #yiv4750670380ygrp-lc .yiv4750670380ad
{margin-bottom:10px;padding:0 0;}#yiv4750670380 #yiv4750670380actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4750670380
#yiv4750670380activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4750670380
#yiv4750670380activity span {font-weight:700;}#yiv4750670380
#yiv4750670380activity span:first-child
{text-transform:uppercase;}#yiv4750670380 #yiv4750670380activity span a
{color:#5085b6;text-decoration:none;}#yiv4750670380 #yiv4750670380activity span
span {color:#ff7900;}#yiv4750670380 #yiv4750670380activity span
.yiv4750670380underline {text-decoration:underline;}#yiv4750670380
.yiv4750670380attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4750670380 .yiv4750670380attach div a
{text-decoration:none;}#yiv4750670380 .yiv4750670380attach img
{border:none;padding-right:5px;}#yiv4750670380 .yiv4750670380attach label
{display:block;margin-bottom:5px;}#yiv4750670380 .yiv4750670380attach label a
{text-decoration:none;}#yiv4750670380 blockquote {margin:0 0 0
4px;}#yiv4750670380 .yiv4750670380bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4750670380
.yiv4750670380bold a {text-decoration:none;}#yiv4750670380 dd.yiv4750670380last
p a {font-family:Verdana;font-weight:700;}#yiv4750670380 dd.yiv4750670380last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4750670380
dd.yiv4750670380last p span.yiv4750670380yshortcuts
{margin-right:0;}#yiv4750670380 div.yiv4750670380attach-table div div a
{text-decoration:none;}#yiv4750670380 div.yiv4750670380attach-table
{width:400px;}#yiv4750670380 div.yiv4750670380file-title a, #yiv4750670380
div.yiv4750670380file-title a:active, #yiv4750670380
div.yiv4750670380file-title a:hover, #yiv4750670380 div.yiv4750670380file-title
a:visited {text-decoration:none;}#yiv4750670380 div.yiv4750670380photo-title a,
#yiv4750670380 div.yiv4750670380photo-title a:active, #yiv4750670380
div.yiv4750670380photo-title a:hover, #yiv4750670380
div.yiv4750670380photo-title a:visited {text-decoration:none;}#yiv4750670380
div#yiv4750670380ygrp-mlmsg #yiv4750670380ygrp-msg p a
span.yiv4750670380yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4750670380
.yiv4750670380green {color:#628c2a;}#yiv4750670380 .yiv4750670380MsoNormal
{margin:0 0 0 0;}#yiv4750670380 o {font-size:0;}#yiv4750670380
#yiv4750670380photos div {float:left;width:72px;}#yiv4750670380
#yiv4750670380photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4750670380
#yiv4750670380photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4750670380
#yiv4750670380reco-category {font-size:77%;}#yiv4750670380
#yiv4750670380reco-desc {font-size:77%;}#yiv4750670380 .yiv4750670380replbq
{margin:4px;}#yiv4750670380 #yiv4750670380ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4750670380 #yiv4750670380ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4750670380
#yiv4750670380ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4750670380
#yiv4750670380ygrp-mlmsg select, #yiv4750670380 input, #yiv4750670380 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4750670380
#yiv4750670380ygrp-mlmsg pre, #yiv4750670380 code {font:115%
monospace;}#yiv4750670380 #yiv4750670380ygrp-mlmsg *
{line-height:1.22em;}#yiv4750670380 #yiv4750670380ygrp-mlmsg #yiv4750670380logo
{padding-bottom:10px;}#yiv4750670380 #yiv4750670380ygrp-msg p a
{font-family:Verdana;}#yiv4750670380 #yiv4750670380ygrp-msg
p#yiv4750670380attach-count span {color:#1E66AE;font-weight:700;}#yiv4750670380
#yiv4750670380ygrp-reco #yiv4750670380reco-head
{color:#ff7900;font-weight:700;}#yiv4750670380 #yiv4750670380ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4750670380 #yiv4750670380ygrp-sponsor
#yiv4750670380ov li a {font-size:130%;text-decoration:none;}#yiv4750670380
#yiv4750670380ygrp-sponsor #yiv4750670380ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4750670380
#yiv4750670380ygrp-sponsor #yiv4750670380ov ul {margin:0;padding:0 0 0
8px;}#yiv4750670380 #yiv4750670380ygrp-text
{font-family:Georgia;}#yiv4750670380 #yiv4750670380ygrp-text p {margin:0 0 1em
0;}#yiv4750670380 #yiv4750670380ygrp-text tt {font-size:120%;}#yiv4750670380
#yiv4750670380ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4750670380
