Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filtering or selecting data baseed on time of day
Hi there. I have rows of date, one field is a start time that has full date
and time of day a phone call was initiated. I want to filter only those calls made between specific times, but across all days (a monthds worth of calls). when I try time based filters it looks at the complete record, i.e. time between one day/time and another day/time. I want to have all days but between times on all those days...any suggestions? thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filtering or selecting data baseed on time of day
Insert a column near to the date and time column. Use the below formula to
get the hour minute format...If you need just the hour use "hh"... =TEXT(I21,"hh:mm") -- If this post helps click Yes --------------- Jacob Skaria "TBA" wrote: Hi there. I have rows of date, one field is a start time that has full date and time of day a phone call was initiated. I want to filter only those calls made between specific times, but across all days (a monthds worth of calls). when I try time based filters it looks at the complete record, i.e. time between one day/time and another day/time. I want to have all days but between times on all those days...any suggestions? thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My cursor is selecting 3 cells at a time - how do I fix this? | Excel Discussion (Misc queries) | |||
filtering time | Excel Worksheet Functions | |||
Filtering Time Cards | Excel Worksheet Functions | |||
Filtering Time ranges | Excel Discussion (Misc queries) | |||
Selecting the first time a number appears | Excel Discussion (Misc queries) |