L
Leo
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. 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!