Re: Date and Time Formula

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

what this part does is test the whole range to be the date of the current
row, and returns only values where those dates match. This way, on a row
where the date is 01/01/2005, it builds an array of values associated with
that date, and ignores the values associted with other dates. MIN then works
on this array to extarct the MIN value for that date.

--
HTH

Bob Phillips

"Sho" <Sho@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6C2EE077-A29B-4316-9E64-8D62AC7F7F87@xxxxxxxxxxxxxxxx
> That is exactly what I wanted. What I do not understand is how it is
> calculating it? Could you explain how the formula is calculating e.g. how
> does IF($A$1:$A$100=A1,$B$1:$B$100) work out that if the date is the same
it
> finds the minimum time?
>
>
> "Sho" wrote:
>
> > Can anyone help with the following;
> >
> > I have dates in column B e.g. 01/05/05 (could be lots of dates on the
same
> > day or different days) and times in Column C e.g. 0900,1545 (all 24hour
> > clock) I want to be able to do a formula that says;
> >
> > If the time in cell C1 is the first time after 0800 on the same date if
it
> > appears in column B, then I want to see the result of 1 appear in D1.
> >
> > e.g.
> >
> > Column B Column C Column D
> > 01/05/05 1045
> > 01/05/05 0930 1
> > 01/05/05 1517
> > 02/05/05 1120 1
> > 02/05/05 1640
> >
> > Any help would be great!


.

Relevant Pages

  • Re: [PATCH V8 08/13] posix clocks: cleanup the CLOCK_DISPTACH macro
    ... extra entry for posix_cpu_timers in the posix_clocks array and do the ... between the legacy static ids and new dynamic ids clear. ... The conclusion from the "dynamic clock as file" discussion was that we ... don't want to add any more static clock ids, ...
    (Linux-Kernel)
  • Re: [PATCH V8 08/13] posix clocks: cleanup the CLOCK_DISPTACH macro
    ... extra entry for posix_cpu_timers in the posix_clocks array and do the ... between the legacy static ids and new dynamic ids clear. ... The conclusion from the "dynamic clock as file" discussion was that we ...
    (Linux-Kernel)
  • Re: Special Relativity is Dead! (second proof)
    ... Dirk Van de moortel schreef: ... where vis the velocity of clock K' at time t according to ... the kid's reference frame, this is rather simple. ... is very simple, but calculating ...
    (sci.physics.relativity)
  • Re: pass an array throuh a function
    ... > so by this opening up an array, in each segment of the array I would have ... This chunk of RAM is the same size as an integer. ... made a data structure called clock? ... Since your data object called 'c' it's of the type 'clock', ...
    (alt.comp.lang.learn.c-cpp)
  • Re: rolling a die
    ... it's the only way to do it with gfortran: ... 'put' argument of 'random_seed' intrinsic at must be an array ... integer:: b, clock, seed, ii, i ... real:: harvest, total, ev ...
    (comp.lang.fortran)