Calculating a decimal into a round number

[brooksc29]

I have a data set with decimals out to the 1000th. Each 1000th represents 1 day. For this exercise, there are 172 days in a year. Is there a formula that will calculate the following decimal into a total number (total days)?

Example is 5.137.

where .172 = 1. (every time the counting number reaches .172 it goes to 1.000 and starts counting again to .172).

The result I need to get is 997.

I'm not sure how to write the formula to convert any text with three decimals to a round number counting the decimals points as singular days.

Any ideas?

 

[shg]

	a​	b​	c​
1​	5.137​	997​	b1: =172*dollarde(a1, 172)

 

[brooksc29]

awesome! so if I have the round number (997) how would I convert it back into the decimal?

 

[shg]

Ici:

	A​	B​	C​
1​	5.137​	997​	B1: =172*DOLLARDE(A1, 172)
2​		5.137​	B2: =DOLLARFR(B1/172, 172)

 

[brooksc29]

perfect!

thanks!

 

[shg]

Yer welcome.