date time formula
 

I am doing a date time formula that will seperate shifts, for instance a
person works from 0630 - 1500, another from 1430 - 2300. Then I have regular
employees that work form 0730 - 1600 and 1500 - 2230. I want to be able to
pull out all emp from 0630-1500 and so on. Is there an easy formula that
will do this?

date time formula
 

This will also include the date as well. Thanks,
"Pammy" wrote:

I am doing a date time formula that will seperate shifts, for instance a
person works from 0630 - 1500, another from 1430 - 2300. Then I have regular
employees that work form 0730 - 1600 and 1500 - 2230. I want to be able to
pull out all emp from 0630-1500 and so on. Is there an easy formula that
will do this?

date time formula
 

Can you give an example of how your data is structured, and your expected
result? It is not clear if all is in one cell, multiple cells, etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Pammy" wrote in message
...
This will also include the date as well. Thanks,
"Pammy" wrote:

I am doing a date time formula that will seperate shifts, for instance a
person works from 0630 - 1500, another from 1430 - 2300. Then I have
regular
employees that work form 0730 - 1600 and 1500 - 2230. I want to be able
to
pull out all emp from 0630-1500 and so on. Is there an easy formula
that
will do this?