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://eileenslounge.com/viewtopic.php?p=316254#p316254
https://eileenslounge.com/viewtopic.php?p=316280#p316280
https://eileenslounge.com/viewtopic.php?p=315915#p315915
https://eileenslounge.com/viewtopic.php?p=315512#p315512
https://eileenslounge.com/viewtopic.php?p=315744#p315744
https://www.eileenslounge.com/viewtopic.php?p=315512#p315512
https://eileenslounge.com/viewtopic.php?p=315680#p315680
https://eileenslounge.com/viewtopic.php?p=315743#p315743
https://www.eileenslounge.com/viewtopic.php?p=315326#p315326
https://www.eileenslounge.com/viewtopic.php?f=30&t=40752
https://eileenslounge.com/viewtopic.php?p=314950#p314950
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=314920#p314920
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=27&t=40621&p=314621#p314621
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

I add a new post

The data obtained are correct

Thanks!