W
William Murray
Hello,
I am by no means an expert at Excel functions. However,
what I am trying although not difficult I can´t get Excel
to give me the results that I want.
I will try to explain as clearly as I can the problem.
I have a total number of hours (that within the formulas
give a running total to the current date). With these
hours I am trying to multiply by a whole number (in
currency)...for example I have a total of 17:40:00 (hours)
I want to multiply that by $200. This gives me a total of
3533:20:00 this is the correct figure as it would be
expressed in pesos (I´m in Mexico). However when I
convert the cell format to Currency it gives me a total of
$147.22 which is only $3200 off.
I don´t know if you need any more information. Please let
me know if you do. I appreciate very much your help.
Believe me this has been frustrating me considerably.
Sincerely,
William E. Murray III
I am by no means an expert at Excel functions. However,
what I am trying although not difficult I can´t get Excel
to give me the results that I want.
I will try to explain as clearly as I can the problem.
I have a total number of hours (that within the formulas
give a running total to the current date). With these
hours I am trying to multiply by a whole number (in
currency)...for example I have a total of 17:40:00 (hours)
I want to multiply that by $200. This gives me a total of
3533:20:00 this is the correct figure as it would be
expressed in pesos (I´m in Mexico). However when I
convert the cell format to Currency it gives me a total of
$147.22 which is only $3200 off.
I don´t know if you need any more information. Please let
me know if you do. I appreciate very much your help.
Believe me this has been frustrating me considerably.
Sincerely,
William E. Murray III