Time Calculation - result "days"

1

I am trying to subtract two dates & times and I would like to result to be expressed as “days only”.  Any  suggestions on how to do this?

2

Hello Steve,

You could use the following formula to subtract two dates & times and give the result with only days (the number is rounded off):

DT1 = Dates & Times #1 Field Code
DT2 = Dates & Times #2 Field Code

ROUND(((DT2 - DT1) / (60*60*24)),0)

 Kintone - Calculation of Date, Time, and Date and Time
 https://get.kintone.help/k/en/user/app_settings/form/autocalc/date_time.html

 Kintone - ROUND Function: Round Off, Round Down, or Round Up Numbers
 https://get.kintone.help/k/en/user/app_settings/form/autocalc/round_function.html

Could you try this to see if it works for you?

Thank you,
Chris