Sum total formula for adding 2 columnson time sheet

J

John Sullivan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
Sumif across a table 2
excell formulas 1
formula for arriving net difference 0
Sum of values in column A based on 0/1 of column B 2
my first excel experience (share portfolio) 2
Formula not being Friendly 3
formula help - avtive early 0

Top