Trouble adding timesheet formulas

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!
 
F

Fred Smith

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

Regards,
Fred
 

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

Top