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.

--
Al