View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default multiply a text box on a report times a dollar amount

Hi

If the times are in Excel times e.g 7:00 for 7 hours, then you will need to
multiply hours x 24 x rate.
Excel stores its times as fractions of a day, hence the need to multiply
by24.

--

Regards
Roger Govier

"gbpg" wrote in message
...
I have a report that adds up the values of a number of fields. I want to
multiply the value in this text box time a dollar amount

I am trying to do this throught the control source with no luck. Any ideas