View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Satya Nanduri Satya Nanduri is offline
external usenet poster
 
Posts: 1
Default Calculating with time

I have a worksheet to calculate wages. I enter the start time, finish time
and the pay rate. I need to get the wages payable which is a simple
multiplication of hours and the pay rate. But when I do that calculation, I
am getting the value based on time value x the pay rate, but not the actual
value. Ex: 8:00 hours x $ 20 returns 6.67 in the wages field.

Can someone help me how to get the actual value in wages field?