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
#yiv1558986022 #yiv1558986022 -- #yiv1558986022ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1558986022
#yiv1558986022ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1558986022
#yiv1558986022ygrp-mkp #yiv1558986022hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1558986022 #yiv1558986022ygrp-mkp #yiv1558986022ads
{margin-bottom:10px;}#yiv1558986022 #yiv1558986022ygrp-mkp .yiv1558986022ad
{padding:0 0;}#yiv1558986022 #yiv1558986022ygrp-mkp .yiv1558986022ad p
{margin:0;}#yiv1558986022 #yiv1558986022ygrp-mkp .yiv1558986022ad a
{color:#0000ff;text-decoration:none;}#yiv1558986022 #yiv1558986022ygrp-sponsor
#yiv1558986022ygrp-lc {font-family:Arial;}#yiv1558986022
#yiv1558986022ygrp-sponsor #yiv1558986022ygrp-lc #yiv1558986022hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1558986022
#yiv1558986022ygrp-sponsor #yiv1558986022ygrp-lc .yiv1558986022ad
{margin-bottom:10px;padding:0 0;}#yiv1558986022 #yiv1558986022actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1558986022
#yiv1558986022activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1558986022
#yiv1558986022activity span {font-weight:700;}#yiv1558986022
#yiv1558986022activity span:first-child
{text-transform:uppercase;}#yiv1558986022 #yiv1558986022activity span a
{color:#5085b6;text-decoration:none;}#yiv1558986022 #yiv1558986022activity span
span {color:#ff7900;}#yiv1558986022 #yiv1558986022activity span
.yiv1558986022underline {text-decoration:underline;}#yiv1558986022
.yiv1558986022attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1558986022 .yiv1558986022attach div a
{text-decoration:none;}#yiv1558986022 .yiv1558986022attach img
{border:none;padding-right:5px;}#yiv1558986022 .yiv1558986022attach label
{display:block;margin-bottom:5px;}#yiv1558986022 .yiv1558986022attach label a
{text-decoration:none;}#yiv1558986022 blockquote {margin:0 0 0
4px;}#yiv1558986022 .yiv1558986022bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1558986022
.yiv1558986022bold a {text-decoration:none;}#yiv1558986022 dd.yiv1558986022last
p a {font-family:Verdana;font-weight:700;}#yiv1558986022 dd.yiv1558986022last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1558986022
dd.yiv1558986022last p span.yiv1558986022yshortcuts
{margin-right:0;}#yiv1558986022 div.yiv1558986022attach-table div div a
{text-decoration:none;}#yiv1558986022 div.yiv1558986022attach-table
{width:400px;}#yiv1558986022 div.yiv1558986022file-title a, #yiv1558986022
div.yiv1558986022file-title a:active, #yiv1558986022
div.yiv1558986022file-title a:hover, #yiv1558986022 div.yiv1558986022file-title
a:visited {text-decoration:none;}#yiv1558986022 div.yiv1558986022photo-title a,
#yiv1558986022 div.yiv1558986022photo-title a:active, #yiv1558986022
div.yiv1558986022photo-title a:hover, #yiv1558986022
div.yiv1558986022photo-title a:visited {text-decoration:none;}#yiv1558986022
div#yiv1558986022ygrp-mlmsg #yiv1558986022ygrp-msg p a
span.yiv1558986022yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1558986022
.yiv1558986022green {color:#628c2a;}#yiv1558986022 .yiv1558986022MsoNormal
{margin:0 0 0 0;}#yiv1558986022 o {font-size:0;}#yiv1558986022
#yiv1558986022photos div {float:left;width:72px;}#yiv1558986022
#yiv1558986022photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1558986022
#yiv1558986022photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1558986022
#yiv1558986022reco-category {font-size:77%;}#yiv1558986022
#yiv1558986022reco-desc {font-size:77%;}#yiv1558986022 .yiv1558986022replbq
{margin:4px;}#yiv1558986022 #yiv1558986022ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1558986022 #yiv1558986022ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1558986022
#yiv1558986022ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1558986022
#yiv1558986022ygrp-mlmsg select, #yiv1558986022 input, #yiv1558986022 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1558986022
#yiv1558986022ygrp-mlmsg pre, #yiv1558986022 code {font:115%
monospace;}#yiv1558986022 #yiv1558986022ygrp-mlmsg *
{line-height:1.22em;}#yiv1558986022 #yiv1558986022ygrp-mlmsg #yiv1558986022logo
{padding-bottom:10px;}#yiv1558986022 #yiv1558986022ygrp-msg p a
{font-family:Verdana;}#yiv1558986022 #yiv1558986022ygrp-msg
p#yiv1558986022attach-count span {color:#1E66AE;font-weight:700;}#yiv1558986022
#yiv1558986022ygrp-reco #yiv1558986022reco-head
{color:#ff7900;font-weight:700;}#yiv1558986022 #yiv1558986022ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1558986022 #yiv1558986022ygrp-sponsor
#yiv1558986022ov li a {font-size:130%;text-decoration:none;}#yiv1558986022
#yiv1558986022ygrp-sponsor #yiv1558986022ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1558986022
#yiv1558986022ygrp-sponsor #yiv1558986022ov ul {margin:0;padding:0 0 0
8px;}#yiv1558986022 #yiv1558986022ygrp-text
{font-family:Georgia;}#yiv1558986022 #yiv1558986022ygrp-text p {margin:0 0 1em
0;}#yiv1558986022 #yiv1558986022ygrp-text tt {font-size:120%;}#yiv1558986022
#yiv1558986022ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1558986022
