Dates Less than 1 duration

edited 12/09/19 in Formulas and Functions

Trying to get a formula to calculate less than day if duration is less than 1 whole day. 

Example - 

Start date is 7/30/2018

End date is 7/30/2018

Duration is .12d

Formula Variable Date is 8/14/2018

If I want to run a formula to calculate the days from Variable date less end date - I get 15.  I am looking for something more exact...should be 14.88.  

Any help would be appriciated 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!