Dear Haris, Mungkin ini bisa membantu. TerimaKasih
Pada Selasa, 7 April 2015 18:36, "'Haris Kartiwan' hkarti...@arahrestu.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear Teman2x Excel dan para Master Excel Saya punya file Report berupa
html, lalu saya buka via Microsoft Excel.Yang saya butuhkan adalah penjumlahan
Jam yang ada di cell warna Merah. Saya tidak berhasil menjumlahkan, mungkin
dikarenakan jam2x tsb berupa character, saya sudah coba menggunakan VALUE dan
juga membuat angka 1 di cell lain lalu di copy paste special (value dan
multiply) tapi masih tetap salah. Mohon bantuannya (file terlampir) atas
masalah saya, Sebelumnya saya mengucapkan Banyak Terima Kasih. SalamHaris
Kartiwan
| | This email is free from viruses and malware because avast! Antivirus
protection is active. |
#yiv7068379827 #yiv7068379827 -- #yiv7068379827ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7068379827
#yiv7068379827ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7068379827
#yiv7068379827ygrp-mkp #yiv7068379827hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7068379827 #yiv7068379827ygrp-mkp #yiv7068379827ads
{margin-bottom:10px;}#yiv7068379827 #yiv7068379827ygrp-mkp .yiv7068379827ad
{padding:0 0;}#yiv7068379827 #yiv7068379827ygrp-mkp .yiv7068379827ad p
{margin:0;}#yiv7068379827 #yiv7068379827ygrp-mkp .yiv7068379827ad a
{color:#0000ff;text-decoration:none;}#yiv7068379827 #yiv7068379827ygrp-sponsor
#yiv7068379827ygrp-lc {font-family:Arial;}#yiv7068379827
#yiv7068379827ygrp-sponsor #yiv7068379827ygrp-lc #yiv7068379827hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7068379827
#yiv7068379827ygrp-sponsor #yiv7068379827ygrp-lc .yiv7068379827ad
{margin-bottom:10px;padding:0 0;}#yiv7068379827 #yiv7068379827actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7068379827
#yiv7068379827activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7068379827
#yiv7068379827activity span {font-weight:700;}#yiv7068379827
#yiv7068379827activity span:first-child
{text-transform:uppercase;}#yiv7068379827 #yiv7068379827activity span a
{color:#5085b6;text-decoration:none;}#yiv7068379827 #yiv7068379827activity span
span {color:#ff7900;}#yiv7068379827 #yiv7068379827activity span
.yiv7068379827underline {text-decoration:underline;}#yiv7068379827
.yiv7068379827attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7068379827 .yiv7068379827attach div a
{text-decoration:none;}#yiv7068379827 .yiv7068379827attach img
{border:none;padding-right:5px;}#yiv7068379827 .yiv7068379827attach label
{display:block;margin-bottom:5px;}#yiv7068379827 .yiv7068379827attach label a
{text-decoration:none;}#yiv7068379827 blockquote {margin:0 0 0
4px;}#yiv7068379827 .yiv7068379827bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7068379827
.yiv7068379827bold a {text-decoration:none;}#yiv7068379827 dd.yiv7068379827last
p a {font-family:Verdana;font-weight:700;}#yiv7068379827 dd.yiv7068379827last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7068379827
dd.yiv7068379827last p span.yiv7068379827yshortcuts
{margin-right:0;}#yiv7068379827 div.yiv7068379827attach-table div div a
{text-decoration:none;}#yiv7068379827 div.yiv7068379827attach-table
{width:400px;}#yiv7068379827 div.yiv7068379827file-title a, #yiv7068379827
div.yiv7068379827file-title a:active, #yiv7068379827
div.yiv7068379827file-title a:hover, #yiv7068379827 div.yiv7068379827file-title
a:visited {text-decoration:none;}#yiv7068379827 div.yiv7068379827photo-title a,
#yiv7068379827 div.yiv7068379827photo-title a:active, #yiv7068379827
div.yiv7068379827photo-title a:hover, #yiv7068379827
div.yiv7068379827photo-title a:visited {text-decoration:none;}#yiv7068379827
div#yiv7068379827ygrp-mlmsg #yiv7068379827ygrp-msg p a
span.yiv7068379827yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7068379827
.yiv7068379827green {color:#628c2a;}#yiv7068379827 .yiv7068379827MsoNormal
{margin:0 0 0 0;}#yiv7068379827 o {font-size:0;}#yiv7068379827
#yiv7068379827photos div {float:left;width:72px;}#yiv7068379827
#yiv7068379827photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7068379827
#yiv7068379827photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7068379827
#yiv7068379827reco-category {font-size:77%;}#yiv7068379827
#yiv7068379827reco-desc {font-size:77%;}#yiv7068379827 .yiv7068379827replbq
{margin:4px;}#yiv7068379827 #yiv7068379827ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7068379827 #yiv7068379827ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7068379827
#yiv7068379827ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7068379827
#yiv7068379827ygrp-mlmsg select, #yiv7068379827 input, #yiv7068379827 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7068379827
#yiv7068379827ygrp-mlmsg pre, #yiv7068379827 code {font:115%
monospace;}#yiv7068379827 #yiv7068379827ygrp-mlmsg *
{line-height:1.22em;}#yiv7068379827 #yiv7068379827ygrp-mlmsg #yiv7068379827logo
{padding-bottom:10px;}#yiv7068379827 #yiv7068379827ygrp-msg p a
{font-family:Verdana;}#yiv7068379827 #yiv7068379827ygrp-msg
p#yiv7068379827attach-count span {color:#1E66AE;font-weight:700;}#yiv7068379827
#yiv7068379827ygrp-reco #yiv7068379827reco-head
{color:#ff7900;font-weight:700;}#yiv7068379827 #yiv7068379827ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7068379827 #yiv7068379827ygrp-sponsor
#yiv7068379827ov li a {font-size:130%;text-decoration:none;}#yiv7068379827
#yiv7068379827ygrp-sponsor #yiv7068379827ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7068379827
#yiv7068379827ygrp-sponsor #yiv7068379827ov ul {margin:0;padding:0 0 0
8px;}#yiv7068379827 #yiv7068379827ygrp-text
{font-family:Georgia;}#yiv7068379827 #yiv7068379827ygrp-text p {margin:0 0 1em
0;}#yiv7068379827 #yiv7068379827ygrp-text tt {font-size:120%;}#yiv7068379827
#yiv7068379827ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7068379827
tabelAbsen_Toby.xls
Description: MS-Excel spreadsheet
