Leave Cell Blank?

  • Thread starter Thread starter viangogh
  • Start date Start date
V

viangogh

Hi

I have a workbook that calculates my salary on a daily and hour basis.
In the first sheet I enter the date, the start and end hour, and it
calculates everything. I have room for 9 days per workbook.

In a second sheet, where I have a table that I can print out and send
to my "boss", I have one row per day I worked. Excel automaticaly
enters the date and hours that I entered in the first sheet in the
correspondent row.

THE PROBLEM:
If I don't work 9 days (imagine I work only 2), I leave the other 7
cells in sheet 1 with the descripton, like "DATE", instead of a real
date. I want the other 7 columns in sheet 2 (of the days I didn't work)
to be left BLANK, instead of automaticaly showing up "DATE" (since it
is what I have written in sheet1...)

In sheet 2 I have:

_|___A__|____B____|___C____|___D____|
1|__Day_|___Date__|_Hours___|_Salary__|
2|___1__|_03-04-04_|___14___|__$140__|
3|___2__|_04-04-04_|___12___|__$120__|
4|___3__|__DATE___|____0___|___$0___|
5|___4__|__DATE___|____0___|___$0___|

B2=Sheet!1B2
B3=Sheet!1B3
B4=Sheet!1B4,
etc

And I what I want to have is:

_|___A__|____B____|___C____|___D____|
1|__Day_|___Date__|_Hours___|_Salary__|
2|___1__|_03-04-04_|___14___|__$140__|
3|___2__|_04-04-04_|___12___|__$120__|
4|______|_________|________|________|
5|______|_________|________|________|


Anyone can help?

Thanks!
 
On Sheet 2 put this formula in B2 =IF(Sheet1!$B2="date","",Sheet1!B2), Copy across and down
HTH
 
Hello!

Thanks everyone for the help!

It worked fine, but now (yet) another problem came up.

I also have room to write the hours of work in the first sheet:

_|___A__|____B____|___C___|
1|_Day__|____1____|___2___|
2|_Date_|_03-03-03_|_Date__|
3|_From_|___10:00__|_From__|
4|__to__|___20:00__|___to__|
5|_Total_|____10___|#VALUE!|

I have B3, C3 and B4, C4 formatted as TIME, and B5, C5 formatted as
CUSTOM - [h].

When I leave one column not filled, the TOTAL of hours becomes
"#VALUE!", since it is expecting to calculate with time, not with
Text... (ex. C3, C4, C5).

I want to do the same I did with "date", with the total of hours in
sheet2, and instead of having "#VALUE!" copied, have a blank cell...

Any suggestions?

Thanks again!
 
It's done!

It just required a little more though!

Thanks again to everyone for the precious help
 
Back
Top