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

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
--
Sincerely, Michael Colvin


"gramps" wrote:

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

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

"gramps" wrote in message
...
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

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


"T. Valko" wrote:

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

"gramps" wrote in message
...
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

Thanx guys, works a treat.
--
Al


"Michael" wrote:

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


"T. Valko" wrote:

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

"gramps" wrote in message
...
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