I am using the following formula and it is not populating a response.
=IF([Time in]@row = ",", IF([Time Out]@row = ",", ([Time Out]@row - [Time in]@row ) * 24))
@Amber K. Unsure what your Time Out and Time In columns contain, but assume it's in some sort of time format.
To subtract the time values, you'll need to wrap both column references in teh TIME() function to create a time object like this:
=IF([Time in]@row = ",", IF([Time Out]@row = ",", (time([Time Out]@row) - time([Time in]@row) ) * 24))
No value is returned. Should show 7 hours.
That is because neither of your time cells equal a comma. If you are trying to get it to run if neither are blank, you would use <> "".
=IF([Time In]@row <> "",
ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
