View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Create a dollar value

If b2 is a rate per hour and b1 reflects the number of hours formatted as time
=B1*24*B2

--
Regards,
Tom Ogilvy


"Good Time" wrote:

Cell B1 is a time formated cell. B2 is formated to dollars. I would
like to creat a formula in cell B3 that multiplies B1 x B2 and returns
a dollar value.