Different formats for the same cell

[Guest]

I work a rolling rota of any 5 days from 7. I produce a duty statement
detailing my duties over a 4 week period. The start and finish times of any
duty are fixed, however my meal relief time is flexible. Column A represents
what I am doing on a particular day whether it be working or resting and
Column E represents the meal relief start time. What I would like to be able
to do is that if I am resting column E will just record that in text format
or if I am working then I will need to be able to input a start time using
hh:mm format. Is it possible to have different cell formats depending on what
I am doing on any particular day.
Many thanks in anticipation.

 

[Guest]

Hi gramps. You could use an if statement in Column E. For example in E2 you
could enter =if(A2="Rest","Rest","") and copy down as far as you need to go.
On your rest days, the E cell will say Rest. If you're working, the cell
will be blank, You could then enter your meal start time. However, you will
wipe out the if formula in that cell when you enter a meal start time. When
you start a new period you could just copy the formula from the E cell on a
Rest day and paste it into the new cells. HTH

 

[T. Valko]

Yes, you can do that.

Assume E1 is the cell in question.

Format the cell as hh:mm

Now, if you enter a time like 1:00 it will retain the hh:mm format. You can
still enter a TEXT value, like, say, Rest.

Biff

 

[Guest]

Thanks, Biff. That is a lot easier than my idea. Michael

 

[Guest]

Thanx guys, works a treat.
--
Al

Thanks, Biff. That is a lot easier than my idea. Michael