How do I get hours from a Date column which has hours tracked?

Platform discussions Special workflows & use cases
1

Hi,

We have two date columns (Start and End) and I need to be able to get the Total Days (in a formula).
i.e. Start 16 Aug, End 18 Aug = 3 days

Now the issue is the end might actually be at mid day on 18 Aug, so we would rather want the answer to be 2.5 days.
This decimal is important as we use it to track progress.

How can I get this?

We have explored the option of adding the “Add Time” option onto our date column and we thought we could subtract it somehow, but we never get this right.

Does anyone have any tips for how to solve this?

2

@Jason_FuzzyLogic,

Currently, times from date columns are not accessible in formulas. Once way to do what you are asking for would be to add an “end time” column as an hour column type. If you do that, this formula would give you a place to start:

IF(AND({End Date},{Start Date}),DAYS(IF({End Date},{End Date},"1/1/21"),IF({Start Date},{Start Date},"1/1/21"))+IF({End Hour},(left({End Hour}&"00",2)+RIGHT("00"&{End Hour},2)/60-8)/8,1),"")

The formula above assumes 8 hours in a work day, starting at 8:00AM.

3

Thanks @JCorrell - your help is really appreciated

4

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