View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
The Code Cage Team[_51_] The Code Cage Team[_51_] is offline
external usenet poster
 
Posts: 1
Default Multiplying mins/hrs by number - incorrect result


The cell that contains the hours worked must be formatted [h]:mm and the
hours worked entered in this format 6:22 the cell doing the calculation
must also be formatted [h]:mm

So in A1 fomatted [h]:mm enter 6:22 in B1 formatted [h]:mm enter
=A1*5.8

Now what do you get? i get 36:55 (you got "36h8m")


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54604