View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default HOW CAN I do"T0 C0NVERT TIMEING IN TO MONEY WITH 'IF' CONDITION"

=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 wrote in message
...
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.....