How to Round Numbers

[Ark68]

In my code, I run into values of a variable (tdur) representing duration (in hours) .

These are some examples:

0.53
1.53
2.11
1.06
1.32
2.64
0.26

I would like to round these to the nearest 30 minutes. So, with these example:

0.5
1.5
2.0
1.0
1.5
3.0
0.5

I thought it was more simple than it is.

 

[mole999]

in the real excel anything over 1 is a day, so you will need to use 24 to get it into a position that it will look like hours, giving you always less than 1, then you could add CEILING. Are you always rounding up or down or allow it to work to natural limits

 

[shg]

[table="width:, class:grid"][tr][td="bgcolor:#c0c0c0"][/td][td="bgcolor:#c0c0c0"]

a​

[/td][td="bgcolor:#c0c0c0"]

b​

[/td][td="bgcolor:#c0c0c0"]

c​

[/td][/tr][tr][td="bgcolor:#c0c0c0"]

2​

[/td][td]

0.53​

[/td][td="bgcolor:#ccffcc"]

0.5​

[/td][td="bgcolor:#ccffcc"]b2: =mround(a2, 0.5)[/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

3​

[/td][td]

1.53​

[/td][td="bgcolor:#ccffcc"]

1.5​

[/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

4​

[/td][td]

2.11​

[/td][td="bgcolor:#ccffcc"]

2.0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

5​

[/td][td]

1.06​

[/td][td="bgcolor:#ccffcc"]

1.0​

[/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

6​

[/td][td]

1.32​

[/td][td="bgcolor:#ccffcc"]

1.5​

[/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

7​

[/td][td]

2.64​

[/td][td="bgcolor:#ccffcc"]

2.5​

[/td][td][/td][/tr]
[tr][td="bgcolor:#c0c0c0"]

8​

[/td][td]

0.26​

[/td][td="bgcolor:#ccffcc"]

0.5​

[/td][td][/td][/tr]
[/table]