Coba formula :
=mod( nilai_yang_akan_dikurangi + 1 - jam_pengurang / 24 , 1 )

Kid.

On Wed, Mar 28, 2012 at 09:35, <[email protected]> wrote:

> Dear Rekan2,
>
> Ada yg tau formula pengurangan jam untuk kasus sperti ini
> Pukul 00:06 dikurangin 1 jam dan hasil yg diinginkan 23:06
>
> Trims atas bantuanya
>
>
> Powered by Telkomsel BlackBerry®
>
> ------------------------------------
>
> +-:: XL-mania ::::::::::::::::::::----------------------------------+
> | Delay pada posting disebabkan sibuknya momods dan leletnya        |
> | koneksi dengan ind***t. bwakakakaka....
> +-------------------------------------------------------------------+
> | 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 di :                                            |
> | http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
> +-------------------------------------------------------------------+
> | Message lama ada di :                                             |
> | http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
> | http://www.mail-archive.com/[email protected]              |
> +-------------------------------------------------------------------+Yahoo!
> Groups Links
>
>
>
>

Kirim email ke