RE: ]] XL-mania [[ Masalah Date-Time

[Farid Abdurrahman]

Kalo diubah format cell-nya doang, ga bisa ngitung kalo harinya 
beda.
Byar bisa, isikan formulanya 
=(B2-A2)*24
dan pastikan Format Cellnya General ato number.
 
B2-A2 akan menghasilkan nilai, satuannya hari
(B2-A2)*24 akan menghasilkan nilai, dg satuan 
jam
 
Rgrds,
Farid A.
 
-----Original Message-----From: XL-mania@yahoogroups.com 
[mailto:[EMAIL PROTECTED]On Behalf Of Anggi 
AnandaSent: Wednesday, April 19, 2006 11:51 AMTo: 
XL-mania@yahoogroups.comSubject: Re: ]] XL-mania [[ Masalah 
Date-Time
Mencoba membantu, mudah-mudahan terselesaikan masalahnya, supaya lebih 
enak atur aja sendiri "format cell" nya OK
 
Salam
Anggi Blackheart
CH_WIBAWA <[EMAIL PROTECTED]> wrote:

  
  
  
  Rekan-rekan XL-mania,
  Mohon bantuannya cara bagaimana 
  mengurangi
  ActualTimeFrom     3/11/06 
  8:00
  ActualTo        
          3/11/06 17:00Jumlah jam  
  =  9
   
  Terima kasih atas bantuannya
   
  Chandra Wibawa


Switch an email 
account to Yahoo! Mail, you could win 
FIFA World Cup tickets. 


-----------------------------------------------------------------------------------
PRIVILEGED AND CONFIDENTIAL (Disclaimer)
-----------------------------------------------------------------------------------
This e-mail message is intended only for the use of the individual or entity to which
it is addressed and may contain information that is privileged, confidential and exempt
from disclosure. If you are not the intended recipient, please do not disseminate,
distribute, or copy this communication, by e-mail or otherwise, or take any action in
reliance on it. Instead, please notify us immediately by return e-mail (including the
original message in your reply) to [EMAIL PROTECTED], and then delete and discard
all copies of the e-mail.







+-:: XL-mania ::::::::::::::::::::----------------------------------+
|                                                                   |
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| [EMAIL PROTECTED] atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni Anda tentang XL-mania di :                      |
| http://www.friendster.com/profiles/xlmania                        |
+-------------------------------------------------------------------+





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "XL-mania" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  









Tanya.xls
Description: Tanya.xls