Validation Confusion-Excel 2003

On a timesheet I need to ensure that when I enter in the times of a the DAY
shift that it is on or after 6:00 am. The finish time is not important as
the start time dictates the shift. For example, someone may start at 7:30
and work thro to 3:30 (or 15:50), this equals a day shift. I may have
someone else who starts at 6:00 am and finishes at 10:00 am, this also equals
a day shift.

I also need an AFTERNOON shift that starts at 12:00 (Noon). I believe if I
have the answer to the day, this will come easy to me (that is if the Noon
time doesn't become a hinderance??)

I also need a NIGHT shift that starts at 7:30 pm (or 19:50).

I also need a standup shift that starts up 21:50 and goes thro to 7:30 the
next morning

These times then need to give me an answer of how many hours they have worked.

When I tried it out on the existing timesheet with a validation rule in
place, it changed the format of the times to reflect something similar to
0.38 (start time) and 0.67 (finish time).

Many thanks to all those who respond.

Many thanks Bruce. I did know, but couldn't get it to work, that you needed
to format back to time. But when I read your reply, I went in formatted the
start/finish time using the Custom settings of hh mm.

Thank you again - now I need to get the next part solved.

"swatsp0p" wrote:

>
> I believe your answers (0.38 (start time) and 0.67 (finish time)) need
> to be formatted as Time. In this format, 0.38 returns 9:07:12 AM and
> 0.67 returns 4:04:48 PM
>
> HTH
>
> Bruce
>
>
> --
> swatsp0p
>
>
> ------------------------------------------------------------------------
> swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
> View this thread: http://www.excelforum.com/showthread...hreadid=396050
>
>