Sum total formula for adding 2 columnson time sheet
I have 2 columns of calculations on each row on hours worked. Each row sum
total is =D6-C6+(D6<C6) for the first column and =G6-F6+(G6<F6) for the second column. Then have a sum total for that row as =E6+H6. Need a formula that will sum the column of all values for =E6+H6 etc for each row. If the sum total is greater than 24 hours at this time with the formula I have, the sum total does not display correctly. It will work as a simple =sum(I6:I12), but if the number of hours is greater than 24, then it will not calculate correctly. |
Sum total formula for adding 2 columnson time sheet
Perhaps this will help, John:
http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "John Sullivan" wrote in message ... I have 2 columns of calculations on each row on hours worked. Each row sum total is =D6-C6+(D6<C6) for the first column and =G6-F6+(G6<F6) for the second column. Then have a sum total for that row as =E6+H6. Need a formula that will sum the column of all values for =E6+H6 etc for each row. If the sum total is greater than 24 hours at this time with the formula I have, the sum total does not display correctly. It will work as a simple =sum(I6:I12), but if the number of hours is greater than 24, then it will not calculate correctly. |
All times are GMT +1. The time now is 01:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com