Hello,
Would really appreciate anyone that could help me figure this one out.
Hello,
Would really appreciate anyone that could help me figure this one out.
Last edited by auswtz; 03-30-2013 at 09:00 PM.
do you intend say 00:30 being counted twice?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi martindwilson,
No, I was thinking of changing the format to below if it helps?
00:00-00:29
00:30-00:59
01:00-01:29
maybe this
Last edited by martindwilson; 03-24-2013 at 09:52 PM.
Thank you so much martindwilson
Last edited by auswtz; 03-30-2013 at 09:02 PM.
see attached file - sheet 2
Last edited by auswtz; 03-30-2013 at 09:01 PM.
nothing on sheet 2
Sorry here it is.
Last edited by auswtz; 03-30-2013 at 09:04 PM.
i cant see the difference, i split column j with text to columns using - as delimiter then used find replace to replace all the - in cols b+c with 0
difference would be in Column A...Instead of starting time of 00:00-00:30, the raw data may commence on 04:00-0:4:15
Column A may not have the complete 24hours (15minutes intervals) as it will skip on times that has no calls entering.
Thanks again for your help with this, Martin
Last edited by auswtz; 03-30-2013 at 09:03 PM.
cant see the difference it will give 0 for any gaps and say 7:15 is in there but not 7:00 it still counts that in the 7:00-7:30 slot (oh and column a are text you need to change those to real times ,put 0 in a spare cell,copy it,select times in col a paste special add,then reformat col a to [h]:mm
Last edited by martindwilson; 03-24-2013 at 11:09 PM.
Oh don't mind me..you're completely right thank you so much for your help martin. Love your work!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks