How can I display "DAY OFF" If time = 00:00 ??

  • Thread starter Thread starter 23shun
  • Start date Start date
2

23shun

Please Help

I am building a Time Sheet in excel 2000.

I have 4 cells.
1. In
2. out
3. lunch
4. total hours for the day.

Cells 1, 2 and 3 are Time Cells and 4 is Number cell.

IF Cell 1 displays 00:00, I would want it to display "DAY OFF" in
cell 1 and 2.

Can you help?
Than you in advance

23shu
 
23Shun

This cannot be done using a simple formula as by putting a formula in Cell 2
(Very easy) to display the DAY OFF text, it would get overwritten when next
used to type in an actual time, unless I am misunderstanding your need.

It could be achieved using a Sheet_Change event coding but that may be a
little over the top for a simple change like that.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
IF Cell 1 displays 00:00, I would want it to display "DAY OFF" in
cell 1 and 2.
Click to expand...

You cannot have Cell 1 display 00:00 and also display "DAY OFF".

You cannot have Cell 2 display text dependent on Cell 1, but also allow data
input into that cell without using VBA.

Why not have Cell 4 display "Day Off"?

In Cell 4 you could have the formula similar to:

=IF(cell1=0,"Day Off",cell2-cell1)

You would need to modify the formula to account for how you are entering
"Lunch".
--ron
 
Hi
if you at least enter 00:00 in BOTH cells manually you could use the
following custom format:
hh:mm,,"Day Off"
 
Back
Top