Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shift Differential TimeSheet Formulas | Excel Worksheet Functions | |||
trouble adding addins | Excel Discussion (Misc queries) | |||
trouble adding addins | Excel Discussion (Misc queries) | |||
Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick, tota | Excel Worksheet Functions | |||
I am having trouble adding a row in Excel. What am i doing wrong? | Excel Worksheet Functions |