Round Numbers. Make the Time numbers nice

[Hurmet_Noka]

Hello Guys
I hope you are well

I have to round these times to nice numbers:

If its 13 becomes 15, to nearest quarter.
I can read the text and convert it to integer and split it to minutes, and hour.
How to round please help?

Do i have to use 100 if statements?

Thank You

[ppr (Peter)]

one of many approaches

one question left: do you also looking for down rounding, like 15:17 → 15:15?

[Hurmet_Noka]

Thank You Peter.
I am looking for:

08:13 → 08.15
14:17 → 14:15
19:29 → 19:30
13:24 → 13:25

[lukasziebold]

Hi Hurmet,

how about this:

MinutesRoundedToQuarter (Type Double) = Math.Ceiling(SampleMinutes / 15) * 15

OH! You want to round down too…

MinutesRoundedToQuarter (Type Double) = Math.Round(SampleMinutes / 15) * 15

Lukas

[Hurmet_Noka]

Perfect.
Now I have to check if its 60 then add one more to the time.

if i have 19:34

How can i substring “9”

Thank You Lukaszie

[ppr (Peter)]

have a look on my samples as this was exactly handling tem 60 min case und jumps up to next hour

[lukasziebold]

Oh what, wait. That’s not good.

You should use DateTime.AddMinutes instead then! No more time right now, I’ll try later

[Hurmet_Noka]

I am looking also for down …
When its 18:11 should be 18:10

Thank You

[ppr (Peter)]

@lukasziebold

Math.Round(SampleMinutes / 15) * 15

combine the approach from Lukasz and mine. Just give me a little time

[ppr (Peter)]

find starter help:
RoundTimesToClosest15MinSegment.xaml (7.7 KB)

[Hurmet_Noka]

Thank You Peter
I will test it now

Regards
Hurmet

[Hurmet_Noka]

I am looking for 5 minutes segment.

11 becomes 10
14 becomes 15
27 becomes 25
32 becomes 30

Thank You

[ppr (Peter)]

so you are looking for a round to the closest 5 segement and not 15?

tsInit.AddMinutes(- tsInit.Minute).AddMinutes(Math.Round(tsInit.Minute / 5) * 5).toString(“HH:mm”)

[Hurmet_Noka]

Yes Sir

[Hurmet_Noka]

This works. I changed 15 to 5 and it works.

Thank You MAN!

[Hurmet_Noka]

Only thing is how to convert “08:30” string to date?

[lukasziebold]

I had to finish this

RoundedTime = SampleTime.AddMinutes((Math.Round(SampleTime.Minute / MinuteInterval ) * MinuteInterval) - SampleTime.Minute)

You can convert strings to dates a number of ways. Lots of examples in the forum. Here is one:

SampleDateTime = DateTime.ParseExact(SampleString,"HH:mm",CultureInfo.InvariantCulture)

Cheers,
Lukas

[Hurmet_Noka]

You are correct, this Works

THANK YOU SIR

All the best