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
|