Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiplying a Vlookup result of 0, getting a value error | Excel Discussion (Misc queries) | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
RSQ function gives incorrect result | Excel Worksheet Functions | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
how do I add times in Excel and result in hours & mins | New Users to Excel |