Dear Master,
Semua rumusnya jalan dengan baik,
saya jadi dapat pencerahan hehehe :)
Makasi banyak semua,
Suwun..
Krisan.
Pada Rabu, 11 Maret 2015 16:38, "Samsudin [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Krisan, Sumbang saran dari saya bisa menggunakan fungsi
=CONCATENATE(text(a1,”d/mm/yyyy”), “ – “,text(a2, ,”d/mm/yyyy”) maka hasilnya
akan menjadi = 08/03/2015 - 09/03/2015. Disini saya menggunakan tanda
penghubung (spasi “-“), jika mau menggunakan yg bisa sesuai dengan kebutuhan.
Hormat saya, Samsudin From: [email protected]
[mailto:[email protected]]
Sent: Wednesday, March 11, 2015 2:27 PM
To: [email protected]
Subject: [belajar-excel] menggabungkan 2 tanggal dalam satu shell Dear Para
Master, Salam,saya punya kesulitan dalam menggabungkan 2 tanggal dalam satu
shell, semisal di shell a1 tanggal 08/03/2015, di shell a2 tanggal 09/03/2015,
kalau saya ingin di shell a3 terdapat 2 gabungan tanggal tersebut biasanya saya
pake rumus dibawah ini di a3=a1&" - "&a2tapi yang keluar di a3 malah bukan
tanggal melainkan 42071 -42072.mohon bantuan agar yang a3 jadi
08/03/2015-09/03/2015, Makasi sebelumnya, Krisan
|
---------------------------------------------------------------------------------------------------
This message (including any attachments) contains confidential information
intended
for a specific individual and purpose, and is protected by law. If you are not
the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or
the
taking of any action based on it, is strictly prohibited. No liability or
responsibility
is accepted if information or data is, for whatever reason corrupted or does
not reach
its intended recipient. No warranty is given that this email is free of
viruses. The
views expressed in this email are, unless otherwise stated, those of the author
and
not those of the Company or its management. The Company reserves the right to
monitor,
intercept and block emails addressed to its users or take any other action in
accordance
with its email use policy. |
#yiv6870698694 #yiv6870698694 -- #yiv6870698694ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6870698694
#yiv6870698694ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6870698694
#yiv6870698694ygrp-mkp #yiv6870698694hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6870698694 #yiv6870698694ygrp-mkp #yiv6870698694ads
{margin-bottom:10px;}#yiv6870698694 #yiv6870698694ygrp-mkp .yiv6870698694ad
{padding:0 0;}#yiv6870698694 #yiv6870698694ygrp-mkp .yiv6870698694ad p
{margin:0;}#yiv6870698694 #yiv6870698694ygrp-mkp .yiv6870698694ad a
{color:#0000ff;text-decoration:none;}#yiv6870698694 #yiv6870698694ygrp-sponsor
#yiv6870698694ygrp-lc {font-family:Arial;}#yiv6870698694
#yiv6870698694ygrp-sponsor #yiv6870698694ygrp-lc #yiv6870698694hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6870698694
#yiv6870698694ygrp-sponsor #yiv6870698694ygrp-lc .yiv6870698694ad
{margin-bottom:10px;padding:0 0;}#yiv6870698694 #yiv6870698694actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6870698694
#yiv6870698694activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6870698694
#yiv6870698694activity span {font-weight:700;}#yiv6870698694
#yiv6870698694activity span:first-child
{text-transform:uppercase;}#yiv6870698694 #yiv6870698694activity span a
{color:#5085b6;text-decoration:none;}#yiv6870698694 #yiv6870698694activity span
span {color:#ff7900;}#yiv6870698694 #yiv6870698694activity span
.yiv6870698694underline {text-decoration:underline;}#yiv6870698694
.yiv6870698694attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6870698694 .yiv6870698694attach div a
{text-decoration:none;}#yiv6870698694 .yiv6870698694attach img
{border:none;padding-right:5px;}#yiv6870698694 .yiv6870698694attach label
{display:block;margin-bottom:5px;}#yiv6870698694 .yiv6870698694attach label a
{text-decoration:none;}#yiv6870698694 blockquote {margin:0 0 0
4px;}#yiv6870698694 .yiv6870698694bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6870698694
.yiv6870698694bold a {text-decoration:none;}#yiv6870698694 dd.yiv6870698694last
p a {font-family:Verdana;font-weight:700;}#yiv6870698694 dd.yiv6870698694last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6870698694
dd.yiv6870698694last p span.yiv6870698694yshortcuts
{margin-right:0;}#yiv6870698694 div.yiv6870698694attach-table div div a
{text-decoration:none;}#yiv6870698694 div.yiv6870698694attach-table
{width:400px;}#yiv6870698694 div.yiv6870698694file-title a, #yiv6870698694
div.yiv6870698694file-title a:active, #yiv6870698694
div.yiv6870698694file-title a:hover, #yiv6870698694 div.yiv6870698694file-title
a:visited {text-decoration:none;}#yiv6870698694 div.yiv6870698694photo-title a,
#yiv6870698694 div.yiv6870698694photo-title a:active, #yiv6870698694
div.yiv6870698694photo-title a:hover, #yiv6870698694
div.yiv6870698694photo-title a:visited {text-decoration:none;}#yiv6870698694
div#yiv6870698694ygrp-mlmsg #yiv6870698694ygrp-msg p a
span.yiv6870698694yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6870698694
.yiv6870698694green {color:#628c2a;}#yiv6870698694 .yiv6870698694MsoNormal
{margin:0 0 0 0;}#yiv6870698694 o {font-size:0;}#yiv6870698694
#yiv6870698694photos div {float:left;width:72px;}#yiv6870698694
#yiv6870698694photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6870698694
#yiv6870698694photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6870698694
#yiv6870698694reco-category {font-size:77%;}#yiv6870698694
#yiv6870698694reco-desc {font-size:77%;}#yiv6870698694 .yiv6870698694replbq
{margin:4px;}#yiv6870698694 #yiv6870698694ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6870698694 #yiv6870698694ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6870698694
#yiv6870698694ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6870698694
#yiv6870698694ygrp-mlmsg select, #yiv6870698694 input, #yiv6870698694 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6870698694
#yiv6870698694ygrp-mlmsg pre, #yiv6870698694 code {font:115%
monospace;}#yiv6870698694 #yiv6870698694ygrp-mlmsg *
{line-height:1.22em;}#yiv6870698694 #yiv6870698694ygrp-mlmsg #yiv6870698694logo
{padding-bottom:10px;}#yiv6870698694 #yiv6870698694ygrp-msg p a
{font-family:Verdana;}#yiv6870698694 #yiv6870698694ygrp-msg
p#yiv6870698694attach-count span {color:#1E66AE;font-weight:700;}#yiv6870698694
#yiv6870698694ygrp-reco #yiv6870698694reco-head
{color:#ff7900;font-weight:700;}#yiv6870698694 #yiv6870698694ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6870698694 #yiv6870698694ygrp-sponsor
#yiv6870698694ov li a {font-size:130%;text-decoration:none;}#yiv6870698694
#yiv6870698694ygrp-sponsor #yiv6870698694ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6870698694
#yiv6870698694ygrp-sponsor #yiv6870698694ov ul {margin:0;padding:0 0 0
8px;}#yiv6870698694 #yiv6870698694ygrp-text
{font-family:Georgia;}#yiv6870698694 #yiv6870698694ygrp-text p {margin:0 0 1em
0;}#yiv6870698694 #yiv6870698694ygrp-text tt {font-size:120%;}#yiv6870698694
#yiv6870698694ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6870698694
