Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help: convert seconds to date and time | Excel Discussion (Misc queries) | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
formula for filtering and a defaulting date | Excel Worksheet Functions | |||
Date and Time Formula | Excel Worksheet Functions |