Re: Is it Possible?

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

Franz

Your an absolute genius. Many thanks for your determined efforts, its
exactly what I require

Thanks


"Franz Verga" <fra68ve@xxxxxxxxxx> wrote in message
news:ux5cQfulGHA.4768@xxxxxxxxxxxxxxxxxxxxxxx
Nel post news:d4Vmg.10521$j7.314275@xxxxxxxxxxxxxx
*John* ha scritto:

I think finally I got it.

Try this one:

=IF(E8-MROUND(E8,15/60/24)>0,MROUND(E8,15/60/24)+15/60/24,MROUND(E8,15/60/24))




Franz

Thanks for your help, it certainly is nearly there and does round to
the nearest 15mins. But I'm looking to get the nearest 'next' 15min.
Sounds confusing but say if E8 showed 8:02 PM I'd want my formula to
return 8:15 PM and not 8:00 PM

But a smart formula you have given nonetheless

Thanks


"Franz Verga" <fra68ve@xxxxxxxxxx> wrote in message
news:%23kbTKSulGHA.3588@xxxxxxxxxxxxxxxxxxxxxxx
Nel post news:e%23uQ$PulGHA.2056@xxxxxxxxxxxxxxxxxxxx
*Franz Verga* ha scritto:

Nel post news:XBUmg.10519$j7.314495@xxxxxxxxxxxxxx
*John* ha scritto:

Is it possible to 'round' a time to the next nearest 15min
interval? As an example in cell A1 I have a value that returns 2:07 PM
(its
formated as h:mm AM/PM), but in B1 I wish to translate this to the
nearest 15min interval in an hour which is 2:15 PM, if the value in
A1 was 5:39 PM I would want to show 5:45 PM in B1 etc etc

Any guidance appreciated


Hi John,

maybe this can help:

=MROUND(E8,15/60/24)

but for 2:07 PM the nearest 15 minutes take to 2:00 PM, instead of
2:15 PM, maybe you can "play" with this formula to find the best
result...

I think I got it:

=MROUND(E8+30/60/60/24,15/60/24)

obviusly in E8 there is the time to round.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy



.

Relevant Pages

  • Re: Is it Possible?
    ... I 've gotted help from the Italian ng... ... *John* ha scritto: ... Franz Verga from Italy ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Is it Possible?
    ... But I'm looking to get the nearest 'next' 15min. ... *Franz Verga* ha scritto: ... but in B1 I wish to translate this to the ... Franz Verga from Italy ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Is it Possible?
    ... *John* ha scritto: ... it certainly is nearly there and does round to ... But I'm looking to get the nearest 'next' 15min. ... *Franz Verga* ha scritto: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Is it Possible?
    ... *Franz Verga* ha scritto: ... formated as h:mm AM/PM), but in B1 I wish to translate this to the ... nearest 15min interval in an hour which is 2:15 PM, ... Franz Verga from Italy ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Common Emitter Config with Negative FB
    ... John S ... flowing through the input source (normally it is accessible somewhere, ... I like to rotate components such that the current probe shows current going from source to load. ...
    (sci.electronics.design)