| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pls Help - blank cell/formula issue
Hi Shokra,
Am Sun, 11 Nov 2012 01:54:16 +0000 schrieb Shokra: There is one problem with the formula though :( That is, it is not removing the overtime hours. There is no overtime, it becomes like hmm "floating hours". So when I applied the formula to E17, it showed his paid hours as 43, when technically if you minus the break & the overtime, he only has 39. what are the regular working hours for each day? Is working on weekend completely overtime? Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting blank cell issue | Excel Programming | |||
| How to return a blank formula cell if the reference is blank? | Excel Worksheet Functions | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
| Formula that will leave cell blank if cell is blank | Excel Programming | |||
Hybrid Mode
