Thread
:
HOW CAN I do"T0 C0NVERT TIMEING IN TO MONEY WITH 'IF' CONDITION"
View Single Post
#
2
Posted to microsoft.public.excel.programming
Bob Phillips
external usenet poster
Posts: 10,593
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.....
Reply With Quote
Bob Phillips
View Public Profile
Find all posts by Bob Phillips