View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Russell Dawson[_2_] Russell Dawson[_2_] is offline
external usenet poster
 
Posts: 181
Default How to multiply time by monitary value

If you are using a template I would have thought that the formulae would
already be in place.
However a simple =a1*b1 should be enough where a1 contains the hours and b1
the rate. Put the formula in c1.
If you are having problems with the currency aspect and are unable to
display the total Rands value it could be a matter of formatting the value
entries as follows.
Format cells - Accounting - Symbol - R English (South Africa)

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Philippe Frydman" wrote:

I am trying to use a templete called weekly time shet and I need to multiply
the billable hours by a Rands value and get a Rands value as an answer. Coyud
you help me with the formula. Thank you