Want to convert Minutes in Days in structure

Sanjivani Wayal

I wanted to convert 1 Hr 45 minutes to days so i followed below steps

1) i converted 1 hr 45 min in minutes by using below :-

WITH _originalestimateM = (originalestimate/60)/1000 -- it is giving me 105 which is correct

2) Now when i try to convert minutes into days which is as per formula divide by 1440 

WITH _originalestimateD = (_originalestimateM /1440)

it gives me 0 where as i wanted to decimal value which comes around 0.0729167 days

 

Is there a way to do it or any other way i can do it?

Oday Rafeh_2jhprw

@Sanjivani Wayal 

It seems like the division is being performed as an integer division, which discards the decimal part of the result. To ensure the result is displayed as a decimal value, you can cast the numerator or the denominator to a floating-point number (float) or a decimal number.

Updated formula:

WITH _originalestimateM = (originalestimate/60)/1000
WITH _originalestimateD = (CAST(_originalestimateM AS float) / 1440)

Regards 

Oday