LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.newusers
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiplying a Vlookup result of 0, getting a value error khatch5995 Excel Discussion (Misc queries) 1 June 27th 07 06:47 PM
vlookup based on random result returns incorrect result rickat Excel Worksheet Functions 1 December 6th 05 01:16 PM
RSQ function gives incorrect result imurch Excel Worksheet Functions 1 November 4th 05 01:35 PM
Median result used in formula gives incorrect result vlatham Excel Worksheet Functions 4 September 21st 05 04:26 PM
how do I add times in Excel and result in hours & mins Rty Shaw New Users to Excel 1 March 4th 05 11:56 AM


All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"