Formula for the difference of Date w/ Time columns

Platform discussions Special workflows & use cases
, , , ,
1

Hello, I am trying to figure out if there is a way to use a formula or another function to find out the difference in time between two date columns.

I can’t use the hour column because the data is being pulled from a WorkForm which doesn’t allow the hour or time tracking fields on the form.

The overall goal is to create a “timesheet” that can just be filled out as a form (but it has to be in WorkForm because I need conditional formatting).

2

@chewonthat

The DAYS() function does that. It will return the difference in days with decimal fractions.

DAYS({To Date}, {From Date})

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: The ITEM ID column - What most people don’t know.
Contact me directly here: Contact – The Monday Man

4

Lifesaver! Thank you so much!

5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.