Skip to main content

We track time and often time there are more than one entry until we get a total. Here is what we do…


{Start Time 1} and {End Time 1} and calculation formula is DATETIME_DIFF({End Time 1},{Start Time 1},‘seconds’)

{Start Time 2} and {End Time 2} and calculation formula is DATETIME_DIFF({End Time 2},{Start Time 2},‘seconds’)

{Start Time 3} and {End Time 3} and calculation formula is DATETIME_DIFF({End Time 3},{Start Time 3},‘seconds’)


Then I have a Total Calculation formula Field: {Calculation 1} + {Calculation 2} + {Calculation 3}


The problem is if one of the calculation fields is empty the Total Calculation field just show “NaN”.


I would love any advice on how to solve this or a better way to calculate overall.

I think I got it…


DATETIME_DIFF({End Time 1},{Start Time 1},‘seconds’)

IF(NOT({End Time 2} = “”), DATETIME_DIFF({End Time 2},{Start Time 2},‘seconds’), BLANK())

IF(NOT({End Time 3} = “”), DATETIME_DIFF({End Time 3},{Start Time 3},‘seconds’), BLANK())

Reply


Terms & Conditions