Trouble adding timesheet formulas

  • Thread starter Thread starter Leo
  • Start date Start date
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!
 
Just sum your times, and you would with any other set of numbers, as in:
=sum(a2:a3)

Regards,
Fred
 
Back
Top