Rabu, 11 Maret 2015

[belajar-excel] Digest Number 3338

3 Messages

Digest #3338
2a
rekap invoice dan surat jalan by "Shilvya mayda Dwinanda" shilvyamd
2b
Re: rekap invoice dan surat jalan by "hendrik karnadi" hendrikkarnadi

Messages

Wed Mar 11, 2015 1:38 am (PDT) . Posted by:

"Samsudin"

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
[cid:image001.jpg@01D05C0C.B11794E0]

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, March 11, 2015 2:27 PM
To: belajar-excel@yahoogroups.com
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&" - "&a2
tapi 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.

Wed Mar 11, 2015 1:39 am (PDT) . Posted by:

"Shilvya mayda Dwinanda" shilvyamd

Assalamu'alaikum wr wb

Nama Saya shilvya mayda ...
saya bekerja di salah satu perusahaan , kebetulan di perusahaan kami masih baru dan belum ada sistem untuk rekapitulasi data .
saya di beri tugas untuk membuat rekapitulasi data invoice dan surat jalan yang saling terhubung satu sama lain , agar jika di find data langsung terhubung ketika barang datang dan tagihan masuk .
tolong bimbingannya dari awal,, saya masih belum begitu faham dengan excel lebih jauh .hanya excel umum dan rekap yang baru saya buat masih menggunakan sistem manual.

terimakasih ,,

wassalamu'alaikum wr wb




Wed Mar 11, 2015 2:07 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Shilvya,Coba dijabarkan proses manualnya dan contoh format input/output yang diinginkan serta penjelasannya dalam sheet2 di Excel.
Salam,HK
From: "Shilvya mayda Dwinanda shilvyamd@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 11 March 2015, 14:47
Subject: [belajar-excel] rekap invoice dan surat jalan

  Assalamu'alaikum wr wb
Nama Saya shilvya mayda ...saya bekerja di salah satu perusahaan , kebetulan di perusahaan kami masih baru dan belum ada sistem untuk rekapitulasi data .saya di beri tugas untuk membuat rekapitulasi data invoice dan surat jalan yang saling terhubung satu sama lain , agar jika di find data langsung terhubung ketika barang datang dan tagihan masuk .tolong bimbingannya dari awal,, saya masih belum begitu faham dengan excel lebih jauh .hanya excel umum dan rekap yang baru saya buat masih menggunakan sistem manual.

terimakasih ,,

wassalamu'alaikum wr wb

#yiv5326624280 #yiv5326624280 -- #yiv5326624280ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5326624280 #yiv5326624280ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5326624280 #yiv5326624280ygrp-mkp #yiv5326624280hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5326624280 #yiv5326624280ygrp-mkp #yiv5326624280ads {margin-bottom:10px;}#yiv5326624280 #yiv5326624280ygrp-mkp .yiv5326624280ad {padding:0 0;}#yiv5326624280 #yiv5326624280ygrp-mkp .yiv5326624280ad p {margin:0;}#yiv5326624280 #yiv5326624280ygrp-mkp .yiv5326624280ad a {color:#0000ff;text-decoration:none;}#yiv5326624280 #yiv5326624280ygrp-sponsor #yiv5326624280ygrp-lc {font-family:Arial;}#yiv5326624280 #yiv5326624280ygrp-sponsor #yiv5326624280ygrp-lc #yiv5326624280hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5326624280 #yiv5326624280ygrp-sponsor #yiv5326624280ygrp-lc .yiv5326624280ad {margin-bottom:10px;padding:0 0;}#yiv5326624280 #yiv5326624280actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5326624280 #yiv5326624280activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5326624280 #yiv5326624280activity span {font-weight:700;}#yiv5326624280 #yiv5326624280activity span:first-child {text-transform:uppercase;}#yiv5326624280 #yiv5326624280activity span a {color:#5085b6;text-decoration:none;}#yiv5326624280 #yiv5326624280activity span span {color:#ff7900;}#yiv5326624280 #yiv5326624280activity span .yiv5326624280underline {text-decoration:underline;}#yiv5326624280 .yiv5326624280attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5326624280 .yiv5326624280attach div a {text-decoration:none;}#yiv5326624280 .yiv5326624280attach img {border:none;padding-right:5px;}#yiv5326624280 .yiv5326624280attach label {display:block;margin-bottom:5px;}#yiv5326624280 .yiv5326624280attach label a {text-decoration:none;}#yiv5326624280 blockquote {margin:0 0 0 4px;}#yiv5326624280 .yiv5326624280bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5326624280 .yiv5326624280bold a {text-decoration:none;}#yiv5326624280 dd.yiv5326624280last p a {font-family:Verdana;font-weight:700;}#yiv5326624280 dd.yiv5326624280last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5326624280 dd.yiv5326624280last p span.yiv5326624280yshortcuts {margin-right:0;}#yiv5326624280 div.yiv5326624280attach-table div div a {text-decoration:none;}#yiv5326624280 div.yiv5326624280attach-table {width:400px;}#yiv5326624280 div.yiv5326624280file-title a, #yiv5326624280 div.yiv5326624280file-title a:active, #yiv5326624280 div.yiv5326624280file-title a:hover, #yiv5326624280 div.yiv5326624280file-title a:visited {text-decoration:none;}#yiv5326624280 div.yiv5326624280photo-title a, #yiv5326624280 div.yiv5326624280photo-title a:active, #yiv5326624280 div.yiv5326624280photo-title a:hover, #yiv5326624280 div.yiv5326624280photo-title a:visited {text-decoration:none;}#yiv5326624280 div#yiv5326624280ygrp-mlmsg #yiv5326624280ygrp-msg p a span.yiv5326624280yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5326624280 .yiv5326624280green {color:#628c2a;}#yiv5326624280 .yiv5326624280MsoNormal {margin:0 0 0 0;}#yiv5326624280 o {font-size:0;}#yiv5326624280 #yiv5326624280photos div {float:left;width:72px;}#yiv5326624280 #yiv5326624280photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5326624280 #yiv5326624280photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5326624280 #yiv5326624280reco-category {font-size:77%;}#yiv5326624280 #yiv5326624280reco-desc {font-size:77%;}#yiv5326624280 .yiv5326624280replbq {margin:4px;}#yiv5326624280 #yiv5326624280ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5326624280 #yiv5326624280ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5326624280 #yiv5326624280ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5326624280 #yiv5326624280ygrp-mlmsg select, #yiv5326624280 input, #yiv5326624280 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5326624280 #yiv5326624280ygrp-mlmsg pre, #yiv5326624280 code {font:115% monospace;}#yiv5326624280 #yiv5326624280ygrp-mlmsg * {line-height:1.22em;}#yiv5326624280 #yiv5326624280ygrp-mlmsg #yiv5326624280logo {padding-bottom:10px;}#yiv5326624280 #yiv5326624280ygrp-msg p a {font-family:Verdana;}#yiv5326624280 #yiv5326624280ygrp-msg p#yiv5326624280attach-count span {color:#1E66AE;font-weight:700;}#yiv5326624280 #yiv5326624280ygrp-reco #yiv5326624280reco-head {color:#ff7900;font-weight:700;}#yiv5326624280 #yiv5326624280ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5326624280 #yiv5326624280ygrp-sponsor #yiv5326624280ov li a {font-size:130%;text-decoration:none;}#yiv5326624280 #yiv5326624280ygrp-sponsor #yiv5326624280ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5326624280 #yiv5326624280ygrp-sponsor #yiv5326624280ov ul {margin:0;padding:0 0 0 8px;}#yiv5326624280 #yiv5326624280ygrp-text {font-family:Georgia;}#yiv5326624280 #yiv5326624280ygrp-text p {margin:0 0 1em 0;}#yiv5326624280 #yiv5326624280ygrp-text tt {font-size:120%;}#yiv5326624280 #yiv5326624280ygrp-vital ul li:last-child {border-right:none !important;}#yiv5326624280

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com

posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com

berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com

keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Tidak ada komentar:

Posting Komentar