Siap pak Matzen,hehehe.. masih penasaran nih,soalnya dengan file yang sama dan
rumus yang sama, di tempat saya hasilnya benar.apakah mungkin karena settingan
komputernya atau format excelnya yang beda ya??penasaran.com
Best Regards,
Fajar Fatahillah
On Thursday, June 4, 2015 9:35 AM, "'Subroto, Matzen'
[email protected] [belajar-excel]" <[email protected]>
wrote:
Dea mas Fajar Terima kasih atas formula ya, akan tetapi ketika saya
coba di hari yang sama hanya berbeda beberapa jam saja, maka hasilnya tidak
sesuai dengan jumlah durasi jam sebenarnya. Terima kasih atas perhatian
dan kerjasamanya, dan saya mohon maaf apabila ada kata-kata yang kurang
berkenan Terima Kasih Matzen From:
[email protected] [mailto:[email protected]]
Sent: 03 Juni 2015 16:56
To: [email protected]
Subject: Re: [belajar-excel] Durasi Waktu [1 Attachment] di excel saya
bisa pak, file terlampir, bisa lihat file excelnya lagi pak? Best
Regards,
Fajar Fatahillah On Wednesday, June 3, 2015 4:42 PM, "'Subroto,
Matzen'[email protected] [belajar-excel]"
<[email protected]> wrote: Untuk formula yang di bawah sudah
saya coba tapi hasilnya seperti ini
| Tanggal start | Tanggal Finish | Waktu start | Waktu Finish | Durasi
waktu yang dipakai |
| 25 Mei 2015 | 26 Mei 2015 | 6:15:10 | 1:30:15 | 19:15:05 |
| 25 Mei 2015 | 27 Mei 2015 | 6:15:10 | 1:30:15 | 19:15:05 |
| 25 Mei 2015 | 30 Mei 2015 | 6:15:10 | 1:30:15 | 19:15:05 |
| 25 Mei 2015 | 02 Juni 2015 | 6:15:10 | 1:30:15 | 19:15:05 |
From:[email protected] [mailto:[email protected]]
Sent: 03 Juni 2015 13:58
To: [email protected]
Subject: Re: [belajar-excel] Durasi Waktu Dear pak Matzen, mungkin
formulanya seperti ini: = ( Tanggal_Finish + Waktu_Finish ) - ( Tanggal_Start
+ Waktu_Start) maaf, tidak bisa melampirkan file excel-nya. cmiiw,
Regards, -putri- Pada 3 Juni 2015 12.53, 'Subroto,
Matzen'[email protected] [belajar-excel]
<[email protected]> menulis: Dear master Semoga semua selalu
dalam Limpahan Berkah dan Hidayah Nya Mohon tambahan ilmunya, dengan kasus yang
saya dapati, yaitu menghitung Durasi waktu dengan hari yang berbeda seperti
file terlampir Terima kasih atas perhatian dan kerjasamanya, dan saya mohon
maaf apabila ada kata-kata yang kurang berkenan Terima Kasih Matzen
____________________________________________________________________________
This email has been scanned for Viruses and Spam. For more information
please contact your local Business Unit Information Security representative.
____________________________________________________________________________
____________________________________________________________________________
This email has been scanned for Viruses and Spam. For more information
please contact your local Business Unit Information Security representative.
____________________________________________________________________________
#yiv2286893234 #yiv2286893234 -- #yiv2286893234ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2286893234
#yiv2286893234ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2286893234
#yiv2286893234ygrp-mkp #yiv2286893234hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2286893234 #yiv2286893234ygrp-mkp #yiv2286893234ads
{margin-bottom:10px;}#yiv2286893234 #yiv2286893234ygrp-mkp .yiv2286893234ad
{padding:0 0;}#yiv2286893234 #yiv2286893234ygrp-mkp .yiv2286893234ad p
{margin:0;}#yiv2286893234 #yiv2286893234ygrp-mkp .yiv2286893234ad a
{color:#0000ff;text-decoration:none;}#yiv2286893234 #yiv2286893234ygrp-sponsor
#yiv2286893234ygrp-lc {font-family:Arial;}#yiv2286893234
#yiv2286893234ygrp-sponsor #yiv2286893234ygrp-lc #yiv2286893234hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2286893234
#yiv2286893234ygrp-sponsor #yiv2286893234ygrp-lc .yiv2286893234ad
{margin-bottom:10px;padding:0 0;}#yiv2286893234 #yiv2286893234actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2286893234
#yiv2286893234activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2286893234
#yiv2286893234activity span {font-weight:700;}#yiv2286893234
#yiv2286893234activity span:first-child
{text-transform:uppercase;}#yiv2286893234 #yiv2286893234activity span a
{color:#5085b6;text-decoration:none;}#yiv2286893234 #yiv2286893234activity span
span {color:#ff7900;}#yiv2286893234 #yiv2286893234activity span
.yiv2286893234underline {text-decoration:underline;}#yiv2286893234
.yiv2286893234attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2286893234 .yiv2286893234attach div a
{text-decoration:none;}#yiv2286893234 .yiv2286893234attach img
{border:none;padding-right:5px;}#yiv2286893234 .yiv2286893234attach label
{display:block;margin-bottom:5px;}#yiv2286893234 .yiv2286893234attach label a
{text-decoration:none;}#yiv2286893234 blockquote {margin:0 0 0
4px;}#yiv2286893234 .yiv2286893234bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2286893234
.yiv2286893234bold a {text-decoration:none;}#yiv2286893234 dd.yiv2286893234last
p a {font-family:Verdana;font-weight:700;}#yiv2286893234 dd.yiv2286893234last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2286893234
dd.yiv2286893234last p span.yiv2286893234yshortcuts
{margin-right:0;}#yiv2286893234 div.yiv2286893234attach-table div div a
{text-decoration:none;}#yiv2286893234 div.yiv2286893234attach-table
{width:400px;}#yiv2286893234 div.yiv2286893234file-title a, #yiv2286893234
div.yiv2286893234file-title a:active, #yiv2286893234
div.yiv2286893234file-title a:hover, #yiv2286893234 div.yiv2286893234file-title
a:visited {text-decoration:none;}#yiv2286893234 div.yiv2286893234photo-title a,
#yiv2286893234 div.yiv2286893234photo-title a:active, #yiv2286893234
div.yiv2286893234photo-title a:hover, #yiv2286893234
div.yiv2286893234photo-title a:visited {text-decoration:none;}#yiv2286893234
div#yiv2286893234ygrp-mlmsg #yiv2286893234ygrp-msg p a
span.yiv2286893234yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2286893234
.yiv2286893234green {color:#628c2a;}#yiv2286893234 .yiv2286893234MsoNormal
{margin:0 0 0 0;}#yiv2286893234 o {font-size:0;}#yiv2286893234
#yiv2286893234photos div {float:left;width:72px;}#yiv2286893234
#yiv2286893234photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2286893234
#yiv2286893234photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2286893234
#yiv2286893234reco-category {font-size:77%;}#yiv2286893234
#yiv2286893234reco-desc {font-size:77%;}#yiv2286893234 .yiv2286893234replbq
{margin:4px;}#yiv2286893234 #yiv2286893234ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2286893234 #yiv2286893234ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2286893234
#yiv2286893234ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2286893234
#yiv2286893234ygrp-mlmsg select, #yiv2286893234 input, #yiv2286893234 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2286893234
#yiv2286893234ygrp-mlmsg pre, #yiv2286893234 code {font:115%
monospace;}#yiv2286893234 #yiv2286893234ygrp-mlmsg *
{line-height:1.22em;}#yiv2286893234 #yiv2286893234ygrp-mlmsg #yiv2286893234logo
{padding-bottom:10px;}#yiv2286893234 #yiv2286893234ygrp-msg p a
{font-family:Verdana;}#yiv2286893234 #yiv2286893234ygrp-msg
p#yiv2286893234attach-count span {color:#1E66AE;font-weight:700;}#yiv2286893234
#yiv2286893234ygrp-reco #yiv2286893234reco-head
{color:#ff7900;font-weight:700;}#yiv2286893234 #yiv2286893234ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2286893234 #yiv2286893234ygrp-sponsor
#yiv2286893234ov li a {font-size:130%;text-decoration:none;}#yiv2286893234
#yiv2286893234ygrp-sponsor #yiv2286893234ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2286893234
#yiv2286893234ygrp-sponsor #yiv2286893234ov ul {margin:0;padding:0 0 0
8px;}#yiv2286893234 #yiv2286893234ygrp-text
{font-family:Georgia;}#yiv2286893234 #yiv2286893234ygrp-text p {margin:0 0 1em
0;}#yiv2286893234 #yiv2286893234ygrp-text tt {font-size:120%;}#yiv2286893234
#yiv2286893234ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2286893234
