Rounding data in Vba

[PcMax]

Hi,

From a list of dates in column B
I used Function that returns the data in column C
I ask what i can do to find rounding of the column D

A B C D
1 26/10/11 19.00 35 19.00.00 19.00
2 26/10/11 19.04 49 19.05.00 19.00
3 26/10/11 19.05 41 19.05.00 19.05
4 26/10/11 19.08 20 19.05.00 19.05

I attach a file with the data to compare, you can get in VBA this rounding in date ?

Thanks in advance

[Rajan_Verma]

=MROUND(B3-INT(B3),5/1440)

Number format
h:mm:ss;@

Thanks
Rajan.

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)
https://eileenslounge.com/viewtopic.php?p=316254#p316254 (https://eileenslounge.com/viewtopic.php?p=316254#p316254)
https://eileenslounge.com/viewtopic.php?p=316280#p316280 (https://eileenslounge.com/viewtopic.php?p=316280#p316280)
https://eileenslounge.com/viewtopic.php?p=315915#p315915 (https://eileenslounge.com/viewtopic.php?p=315915#p315915)
https://eileenslounge.com/viewtopic.php?p=315512#p315512 (https://eileenslounge.com/viewtopic.php?p=315512#p315512)
https://eileenslounge.com/viewtopic.php?p=315744#p315744 (https://eileenslounge.com/viewtopic.php?p=315744#p315744)
https://www.eileenslounge.com/viewtopic.php?p=315512#p315512 (https://www.eileenslounge.com/viewtopic.php?p=315512#p315512)
https://eileenslounge.com/viewtopic.php?p=315680#p315680 (https://eileenslounge.com/viewtopic.php?p=315680#p315680)
https://eileenslounge.com/viewtopic.php?p=315743#p315743 (https://eileenslounge.com/viewtopic.php?p=315743#p315743)
https://www.eileenslounge.com/viewtopic.php?p=315326#p315326 (https://www.eileenslounge.com/viewtopic.php?p=315326#p315326)
https://www.eileenslounge.com/viewtopic.php?f=30&t=40752 (https://www.eileenslounge.com/viewtopic.php?f=30&t=40752)
https://eileenslounge.com/viewtopic.php?p=314950#p314950 (https://eileenslounge.com/viewtopic.php?p=314950#p314950)
https://www.eileenslounge.com/viewtopic.php?p=314940#p314940 (https://www.eileenslounge.com/viewtopic.php?p=314940#p314940)
https://www.eileenslounge.com/viewtopic.php?p=314926#p314926 (https://www.eileenslounge.com/viewtopic.php?p=314926#p314926)
https://www.eileenslounge.com/viewtopic.php?p=314920#p314920 (https://www.eileenslounge.com/viewtopic.php?p=314920#p314920)
https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314837#p314837 (https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314837#p314837)
https://www.eileenslounge.com/viewtopic.php?f=21&t=40701&p=314836#p314836 (https://www.eileenslounge.com/viewtopic.php?f=21&t=40701&p=314836#p314836)
https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314621#p314621 (https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314621#p314621)
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)

[Rick Rothstein]

Hi,

From a list of dates in column B
I used Function that returns the data in column C
I ask what i can do to find rounding of the column D

A B C D
1 26/10/11 19.00 35 19.00.00 19.00
2 26/10/11 19.04 49 19.05.00 19.00
3 26/10/11 19.05 41 19.05.00 19.05
4 26/10/11 19.08 20 19.05.00 19.05

I believe you want this formula...

=MROUND(MOD(B3-TIME(0,2,30),1),MOD(TIME(0,5,0),1))

You will need to format the cells using this...

h:mm;@

[PcMax]

Hi,

The suggestions require components of financial analysis.
I added references and tested formulas.

I thank Rick with the suggestion:
=MROUND(MOD(B3-TIME(0,2,30),1),MOD(TIME(0,5,0),1))

What is the exact matches

[Rick Rothstein]

I thank Rick with the suggestion:
=MROUND(MOD(B3-TIME(0,2,30),1),MOD(TIME(0,5,0),1))

What is the exact matches
What do you mean by "What is the exact matches"? I don't understand what you are referring to.

[PcMax]

Hi,


What is the exact matches

Rick, I translated: Google Traduttore (http://translate.google.it/#it|en|)

I add a new post

The data obtained are correct

Thanks!