| Home |
| Search |
| Today's Posts |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to calculate hours worked
It make the formula a bit longer but try =SUM(IF(ISNUMBER(LEFT(A1:G1,5)+0),RIGHT(A1:G1,5)-LEFT(A1:G1,5)-(RIGHT(A1:G1,5)-LEFT(A1:G1,5)=1/3)*1/24))*24 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=501797 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating numbers of hours worked in pay divisions | Excel Discussion (Misc queries) | |||
| How do I write the formula to calculate someones time worked | Excel Worksheet Functions | |||
| How do I calculate hours in Excel | New Users to Excel | |||
| How to calculate hours? | Excel Worksheet Functions | |||
| Excel needs hh:mm where hh>24 for hours worked per week | Excel Worksheet Functions | |||
Threaded Mode
