| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumhours at end of the week
Hi
Try =SUM(F4:I4) although that is only 4 cells, and you mentioned 5! But at least you can see how the formula should be set out! Andy. "OSSIE" wrote in message ... Hi im tring to sum the value of 5 different cells that already have aformula in i tried =sum (f4,i4 and so for but the resul its 8 when the actual result should be 40 any ideas in what im doing wrong any help would be appreciated A4 has the name of the employee d4 the time he or she came in E4 time out and f4 the total hours - the 1/2 for lunch and i want to sum the total hours worked at the end of the week Thanks again for you help -- OSSIE ------------------------------------------------------------------------ OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638 View this thread: http://www.excelforum.com/showthread...hreadid=526144 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
| Macro to insert copied cells | Excel Discussion (Misc queries) | |||
| Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
| user defined function | Excel Worksheet Functions | |||
| Line or bar graphs for tracking stocks profit and loss. | Charts and Charting in Excel | |||
Hybrid Mode
