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

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

23shun


---
Message posted from http://www.ExcelForum.com/

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"23shun >" <<23shun.19efbj@excelforum-nospam.com> wrote in message
news:23shun.19efbj@excelforum-nospam.com...
> 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
>
> 23shun
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

On Wed, 14 Jul 2004 1409 -0500, 23shun
<<23shun.19efbj@excelforum-nospam.com>> wrote:

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

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"

--
Regards
Frank Kabel
Frankfurt, Germany


> 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
>
> 23shun
>
>
> ---
> Message posted from http://www.ExcelForum.com/