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.
____________________________________________________________________________
#yiv0173790797 #yiv0173790797 -- #yiv0173790797ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0173790797
#yiv0173790797ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0173790797
#yiv0173790797ygrp-mkp #yiv0173790797hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0173790797 #yiv0173790797ygrp-mkp #yiv0173790797ads
{margin-bottom:10px;}#yiv0173790797 #yiv0173790797ygrp-mkp .yiv0173790797ad
{padding:0 0;}#yiv0173790797 #yiv0173790797ygrp-mkp .yiv0173790797ad p
{margin:0;}#yiv0173790797 #yiv0173790797ygrp-mkp .yiv0173790797ad a
{color:#0000ff;text-decoration:none;}#yiv0173790797 #yiv0173790797ygrp-sponsor
#yiv0173790797ygrp-lc {font-family:Arial;}#yiv0173790797
#yiv0173790797ygrp-sponsor #yiv0173790797ygrp-lc #yiv0173790797hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0173790797
#yiv0173790797ygrp-sponsor #yiv0173790797ygrp-lc .yiv0173790797ad
{margin-bottom:10px;padding:0 0;}#yiv0173790797 #yiv0173790797actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0173790797
#yiv0173790797activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0173790797
#yiv0173790797activity span {font-weight:700;}#yiv0173790797
#yiv0173790797activity span:first-child
{text-transform:uppercase;}#yiv0173790797 #yiv0173790797activity span a
{color:#5085b6;text-decoration:none;}#yiv0173790797 #yiv0173790797activity span
span {color:#ff7900;}#yiv0173790797 #yiv0173790797activity span
.yiv0173790797underline {text-decoration:underline;}#yiv0173790797
.yiv0173790797attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0173790797 .yiv0173790797attach div a
{text-decoration:none;}#yiv0173790797 .yiv0173790797attach img
{border:none;padding-right:5px;}#yiv0173790797 .yiv0173790797attach label
{display:block;margin-bottom:5px;}#yiv0173790797 .yiv0173790797attach label a
{text-decoration:none;}#yiv0173790797 blockquote {margin:0 0 0
4px;}#yiv0173790797 .yiv0173790797bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0173790797
.yiv0173790797bold a {text-decoration:none;}#yiv0173790797 dd.yiv0173790797last
p a {font-family:Verdana;font-weight:700;}#yiv0173790797 dd.yiv0173790797last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0173790797
dd.yiv0173790797last p span.yiv0173790797yshortcuts
{margin-right:0;}#yiv0173790797 div.yiv0173790797attach-table div div a
{text-decoration:none;}#yiv0173790797 div.yiv0173790797attach-table
{width:400px;}#yiv0173790797 div.yiv0173790797file-title a, #yiv0173790797
div.yiv0173790797file-title a:active, #yiv0173790797
div.yiv0173790797file-title a:hover, #yiv0173790797 div.yiv0173790797file-title
a:visited {text-decoration:none;}#yiv0173790797 div.yiv0173790797photo-title a,
#yiv0173790797 div.yiv0173790797photo-title a:active, #yiv0173790797
div.yiv0173790797photo-title a:hover, #yiv0173790797
div.yiv0173790797photo-title a:visited {text-decoration:none;}#yiv0173790797
div#yiv0173790797ygrp-mlmsg #yiv0173790797ygrp-msg p a
span.yiv0173790797yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0173790797
.yiv0173790797green {color:#628c2a;}#yiv0173790797 .yiv0173790797MsoNormal
{margin:0 0 0 0;}#yiv0173790797 o {font-size:0;}#yiv0173790797
#yiv0173790797photos div {float:left;width:72px;}#yiv0173790797
#yiv0173790797photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0173790797
#yiv0173790797photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0173790797
#yiv0173790797reco-category {font-size:77%;}#yiv0173790797
#yiv0173790797reco-desc {font-size:77%;}#yiv0173790797 .yiv0173790797replbq
{margin:4px;}#yiv0173790797 #yiv0173790797ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0173790797 #yiv0173790797ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0173790797
#yiv0173790797ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0173790797
#yiv0173790797ygrp-mlmsg select, #yiv0173790797 input, #yiv0173790797 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0173790797
#yiv0173790797ygrp-mlmsg pre, #yiv0173790797 code {font:115%
monospace;}#yiv0173790797 #yiv0173790797ygrp-mlmsg *
{line-height:1.22em;}#yiv0173790797 #yiv0173790797ygrp-mlmsg #yiv0173790797logo
{padding-bottom:10px;}#yiv0173790797 #yiv0173790797ygrp-msg p a
{font-family:Verdana;}#yiv0173790797 #yiv0173790797ygrp-msg
p#yiv0173790797attach-count span {color:#1E66AE;font-weight:700;}#yiv0173790797
#yiv0173790797ygrp-reco #yiv0173790797reco-head
{color:#ff7900;font-weight:700;}#yiv0173790797 #yiv0173790797ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0173790797 #yiv0173790797ygrp-sponsor
#yiv0173790797ov li a {font-size:130%;text-decoration:none;}#yiv0173790797
#yiv0173790797ygrp-sponsor #yiv0173790797ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0173790797
#yiv0173790797ygrp-sponsor #yiv0173790797ov ul {margin:0;padding:0 0 0
8px;}#yiv0173790797 #yiv0173790797ygrp-text
{font-family:Georgia;}#yiv0173790797 #yiv0173790797ygrp-text p {margin:0 0 1em
0;}#yiv0173790797 #yiv0173790797ygrp-text tt {font-size:120%;}#yiv0173790797
#yiv0173790797ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0173790797
Durasi.xlsx
Description: MS-Excel 2007 spreadsheet
