View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
davidderolph
 
Posts: n/a
Default how to calculate the hours and minutes in excel

You are confusing minutes with decimals. 30 minutes is 1/2 or 0.5 hours. 15
minutes is 1/4 or 0.25 hours, etc.

"Mital" wrote:

I am trying to calculate the total hours and minutes by weelky in excel. The
problem is if the hours are 10.5 ( 10hour and 30 minutes). IF i calculate the
10.5 by $14 and hour it gives me 147. but if i multiply 10.30 by 14, it gives
me 144.2. I am confused i don;t know what i should do. Please help me. Thank
u in advance