View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Randi Randi is offline
external usenet poster
 
Posts: 28
Default Multiplying mins/hrs by number - incorrect result

I am trying to multiple 6h22m by 5.8 people.
When I do the calculations by hand I get I get 36h8m.
The formula gives me 12h55m. The cell formats
are above the numbers. Does anyone know what
I'm doing wrong. Any help is appreciated. Thanks.

H:mm # 2 dec h:mm
6:22 X 5.80 = 12:55