yoo agung,
= ( ROUNDDOWN ( E3 / 60 ; 0 )  & " : " & MOD ( E3 ; 60 ) ) + F3

ganti titik koma ";" dengan koma "," bila kompi setempat berigional english. br,

odong nando
 


    Pada Senin, 14 Desember 2015 13:53, "[email protected] [belajar-excel]" 
<[email protected]> menulis:
 

     dear para master mohon pencerahan dari kasus saya berikutsaya kesulitan 
untuk menentukan kapan selesai dari target pekerjaan yang akan saya planning 
kan karena saya tidak bisa merubah waktu pengerjaan hasil perhitungan ke dalam 
format jam atau menit,mohon pencerahannya  #yiv3538041164 #yiv3538041164 -- 
#yiv3538041164ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 
0;padding:0 10px;}#yiv3538041164 #yiv3538041164ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv3538041164 #yiv3538041164ygrp-mkp #yiv3538041164hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3538041164 #yiv3538041164ygrp-mkp #yiv3538041164ads 
{margin-bottom:10px;}#yiv3538041164 #yiv3538041164ygrp-mkp .yiv3538041164ad 
{padding:0 0;}#yiv3538041164 #yiv3538041164ygrp-mkp .yiv3538041164ad p 
{margin:0;}#yiv3538041164 #yiv3538041164ygrp-mkp .yiv3538041164ad a 
{color:#0000ff;text-decoration:none;}#yiv3538041164 #yiv3538041164ygrp-sponsor 
#yiv3538041164ygrp-lc {font-family:Arial;}#yiv3538041164 
#yiv3538041164ygrp-sponsor #yiv3538041164ygrp-lc #yiv3538041164hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3538041164 
#yiv3538041164ygrp-sponsor #yiv3538041164ygrp-lc .yiv3538041164ad 
{margin-bottom:10px;padding:0 0;}#yiv3538041164 #yiv3538041164actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3538041164 
#yiv3538041164activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3538041164
 #yiv3538041164activity span {font-weight:700;}#yiv3538041164 
#yiv3538041164activity span:first-child 
{text-transform:uppercase;}#yiv3538041164 #yiv3538041164activity span a 
{color:#5085b6;text-decoration:none;}#yiv3538041164 #yiv3538041164activity span 
span {color:#ff7900;}#yiv3538041164 #yiv3538041164activity span 
.yiv3538041164underline {text-decoration:underline;}#yiv3538041164 
.yiv3538041164attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3538041164 .yiv3538041164attach div a 
{text-decoration:none;}#yiv3538041164 .yiv3538041164attach img 
{border:none;padding-right:5px;}#yiv3538041164 .yiv3538041164attach label 
{display:block;margin-bottom:5px;}#yiv3538041164 .yiv3538041164attach label a 
{text-decoration:none;}#yiv3538041164 blockquote {margin:0 0 0 
4px;}#yiv3538041164 .yiv3538041164bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3538041164 
.yiv3538041164bold a {text-decoration:none;}#yiv3538041164 dd.yiv3538041164last 
p a {font-family:Verdana;font-weight:700;}#yiv3538041164 dd.yiv3538041164last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3538041164 
dd.yiv3538041164last p span.yiv3538041164yshortcuts 
{margin-right:0;}#yiv3538041164 div.yiv3538041164attach-table div div a 
{text-decoration:none;}#yiv3538041164 div.yiv3538041164attach-table 
{width:400px;}#yiv3538041164 div.yiv3538041164file-title a, #yiv3538041164 
div.yiv3538041164file-title a:active, #yiv3538041164 
div.yiv3538041164file-title a:hover, #yiv3538041164 div.yiv3538041164file-title 
a:visited {text-decoration:none;}#yiv3538041164 div.yiv3538041164photo-title a, 
#yiv3538041164 div.yiv3538041164photo-title a:active, #yiv3538041164 
div.yiv3538041164photo-title a:hover, #yiv3538041164 
div.yiv3538041164photo-title a:visited {text-decoration:none;}#yiv3538041164 
div#yiv3538041164ygrp-mlmsg #yiv3538041164ygrp-msg p a 
span.yiv3538041164yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3538041164 
.yiv3538041164green {color:#628c2a;}#yiv3538041164 .yiv3538041164MsoNormal 
{margin:0 0 0 0;}#yiv3538041164 o {font-size:0;}#yiv3538041164 
#yiv3538041164photos div {float:left;width:72px;}#yiv3538041164 
#yiv3538041164photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv3538041164 
#yiv3538041164photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3538041164
 #yiv3538041164reco-category {font-size:77%;}#yiv3538041164 
#yiv3538041164reco-desc {font-size:77%;}#yiv3538041164 .yiv3538041164replbq 
{margin:4px;}#yiv3538041164 #yiv3538041164ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3538041164 #yiv3538041164ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3538041164 
#yiv3538041164ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3538041164 
#yiv3538041164ygrp-mlmsg select, #yiv3538041164 input, #yiv3538041164 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3538041164 
#yiv3538041164ygrp-mlmsg pre, #yiv3538041164 code {font:115% 
monospace;}#yiv3538041164 #yiv3538041164ygrp-mlmsg * 
{line-height:1.22em;}#yiv3538041164 #yiv3538041164ygrp-mlmsg #yiv3538041164logo 
{padding-bottom:10px;}#yiv3538041164 #yiv3538041164ygrp-msg p a 
{font-family:Verdana;}#yiv3538041164 #yiv3538041164ygrp-msg 
p#yiv3538041164attach-count span {color:#1E66AE;font-weight:700;}#yiv3538041164 
#yiv3538041164ygrp-reco #yiv3538041164reco-head 
{color:#ff7900;font-weight:700;}#yiv3538041164 #yiv3538041164ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv3538041164 #yiv3538041164ygrp-sponsor 
#yiv3538041164ov li a {font-size:130%;text-decoration:none;}#yiv3538041164 
#yiv3538041164ygrp-sponsor #yiv3538041164ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3538041164 
#yiv3538041164ygrp-sponsor #yiv3538041164ov ul {margin:0;padding:0 0 0 
8px;}#yiv3538041164 #yiv3538041164ygrp-text 
{font-family:Georgia;}#yiv3538041164 #yiv3538041164ygrp-text p {margin:0 0 1em 
0;}#yiv3538041164 #yiv3538041164ygrp-text tt {font-size:120%;}#yiv3538041164 
#yiv3538041164ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv3538041164 

  

Kirim email ke