HOW CAN I do"T0 C0NVERT TIMEING IN TO MONEY WITH 'IF' CONDITION"

's Computer Specifications

Hi,

I want to know about IF condition to convert the puls of minutes in to Money

as for exp. 0:15 is 1 puls of timeing and the rate of one plus is 5/- Rs.
only..

now i want to know that how can i create the formula to counting this pulses
and convert for Rs.

i hope i can find perfect answer by you....
thanks in advance.....

's Computer Specifications

=A1/TIME(0,15,0)*5

or

=A1*96*5

what happens if the time is not an exact multiple of 15 mins.
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"harpal barad" <harpal (E-Mail Removed)> wrote in message
news:83EE6AB1-4E89-4463-9E81-(E-Mail Removed)...
> Hi,
>
> I want to know about IF condition to convert the puls of minutes in to
> Money
>
> as for exp. 0:15 is 1 puls of timeing and the rate of one plus is 5/- Rs.
> only..
>
> now i want to know that how can i create the formula to counting this
> pulses
> and convert for Rs.
>
> i hope i can find perfect answer by you....
> thanks in advance.....

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting: How to set condition "formula" with is "date"formatted	AA Arens	Microsoft Excel Discussion	10	31st Jan 2008 01:57 AM
Outlook 2003 rules: Can one specify "AND" vice "OR" condition	=?Utf-8?B?Wm9yYW4gZnJvbSBCLWluLXRoZS11aw==?=	Microsoft Outlook Discussion	0	26th Oct 2006 12:27 PM
"Rule based design" or "event-condition-action" pattern?	feng	Microsoft VB .NET	1	28th Feb 2005 09:18 AM
Outlook 2002 SP3 -> Tasks -> Custom Filter -> Advanced - ignores condition/value "between"/"last year and next friday"	pluto@jupiter.info	Microsoft Outlook	1	27th Jan 2005 05:11 PM
Customize Current View > Filter > Advanced > Feild="Location", Condition="is not empty"	=?Utf-8?B?SnVzdGlu?=	Microsoft Outlook Calendar	5	24th Mar 2004 03:08 AM