LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 39
Default right function on a mm/dd/yy tt:tt:tt field

Hi Again All,

I have a slew of dates and times (measured out as far as seconds) in a
12-month range, and they need to be grouped as "Rows where mm/dd/yy tt:tt:tt"
is from 0:00 (midnight)-8:00am, 8:01am-4:00pm, and 4:01pm-11:59pm. I have an
auxiliary column I've placed adjecent to this column, but I can't seem to get
it done. Pivot Tables and grouping won't do it, because there are so many
unique values (6000) that the pivot table simply won't generate. (I've
attempted creating it 15 times using the Month column for rows and the d/t
column for columns, and it goes through the pivot creation without issue, but
when you click "Finish", nothing happens.) Any ideas?

Thanks,

Jamie

(Guess it's time for me to start looking at the questions to see what I can
help with, if only to offset my increasing number of requests. :) )
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validation source field size and function. Dudedad Excel Discussion (Misc queries) 1 June 20th 07 07:47 PM
Using a field name in an IF function for a calculated field in a PivotTable Joel P Excel Worksheet Functions 0 March 29th 07 12:48 AM
how do i get field name from result of MAX or LARGE function nick Excel Worksheet Functions 4 August 13th 06 06:32 AM
Insert Function field? Jenn Warren Excel Discussion (Misc queries) 1 May 23rd 06 01:10 AM
vlookup and a function field input Patrick Excel Worksheet Functions 2 April 27th 06 04:38 PM


All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"