|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 16th, 2009, 03:57 AM
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
April 16th, 2009, 05:11 AM
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!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
