Shift Differential
How can I write a formula for shift differential if 06:00-14:00 is normal working, 14:00-22:00 is $1.00 more an hour and 22:00-06:00 is .90 more an hour? (A5 Work Hours ) (B5-Sunday start) (C5- Sunday End) (D5- Monday Start) (E5- Monday End) etc. Thanks you to any one that can help.

Answer Question   |  February 22, 2008  2:11 AM
Excel 2003, Microsoft Excel

Excel 2003 Cell has formula but empty Value or text
Hya I have a formula into Excel worksheet cell this value comes from out side Excel. sometimes there is a number and sometimes it contains nothing. I have used isblank isempty when the cell is empty and they return true (due to the formula inside the cell) do u thing i can chek if the [...]

Answer Question   |  February 19, 2008  8:17 AM
Excel 2003, NULL

Excel cell referencing across worksheets
In the past I used to be able to caculate a cell reference on another worksheet in the same spreadsheet and get the value(contents) and use it in the worksheet that was referencing out, but this feature seems to have disappeared. At present I am using Excel 2003. Any suggestions?

Answer Question   |  February 18, 2008  6:18 AM
Excel 2003, Microsoft Excel