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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.....
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting with VBA 4
How can I migrate MBOX to PST? 2
What software do you use to convert between audio files? 6
Increment Number by on unsorted list 3
How do I use Outlook Journal to prompt for time recording informa. 1
how to get values at a time step and use it in a ctstep 0
count if two conditions in two arrays are true 1
Understanding and comparing stock market figures 10

Back
Top