| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time series
I have several tabs for different dates with data in it. Colomn G contains the time in format 13:30:30. For my project, I require to know the number of data points in various time series, pls see below. 7:30:00 8:30:00 8:30:00 9:30:00 9:30:00 10:30:00 10:30:00 11:30:00 11:30:00 12:30:00 12:30:00 13:30:00 13:30:00 14:30:00 14:30:00 15:30:00 15:30:00 16:00:00 I tried countif and if function but could not come up with the results, PLS HELP. If I have to do it manually then I am dead...... -- mohitmahajan ------------------------------------------------------------------------ mohitmahajan's Profile: http://www.excelforum.com/member.php...fo&userid=8130 View this thread: http://www.excelforum.com/showthread...hreadid=492678 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Click Boxes for each series in a graph | Charts and Charting in Excel | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Time and motion chart | Charts and Charting in Excel | |||
| Quasi Transpose / Stacking Columns | Excel Worksheet Functions | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
