Trouble adding timesheet formulas
 

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!

Trouble adding timesheet formulas
 

Just sum your times, and you would with any other set of numbers, as in:
=sum(a2:a3)

Regards,
Fred

"Leo" wrote in message
...
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!