Trying to add two rows of times with the result in one cell, but having
trouble. The result for each row displays fine in the HOURS WORKED column on
a per-row basis €“ but I need to display just one result for both rows - in
the bottom cell of the HOURS WORKED column for that day.
The formulas for each row are show below. IF statements are for standard
(12-hr.) time format, text option, and so that 'zero' hours are not displayed.

Row 1 formula:
=IF((ISTEXT(T34)),"",IF(ROUND((((U34-T34)+(W34-V34))-INT((U34-T34)+(W34-V34)))*24,2)=0,"",ROUND((((U34-T34)+(W34-V34))-INT((U34-T34)+(W34-V34)))*24,2)))

Row 2 formula:
=IF((ISTEXT(T35)),"",IF(ROUND((((U35-T35)+(W35-V35))-INT((U35-T35)+(W35-V35)))*24,2)=0,"",ROUND((((U35-T35)+(W35-V35))-INT((U35-T35)+(W35-V35)))*24,2)))

Timesheet format is as follows:

TIMES HOURS
IN OUT IN OUT WORKED
Row 1
Row 2 Need total hrs.
for both rows here

Thank you for any help you can send my way!