Formula Duration in Hours
I am importing a .csv file with two date columns. The date columns are formatted Date & Time. I need a formula that calculates the number of hours between the two date / time columns but doesn'...
Forum Discussion
You could make 2 fields -
Formula Duration type named [Date Time Duration] = [End DateTime]-[Start DateTime]
then a Formula Numeric Type named [Hours] = Floor(ToHours([Date Time Duration]))
Formula Duration type named [Date Time Duration] = [End DateTime]-[Start DateTime]
then a Formula Numeric Type named [Hours] = Floor(ToHours([Date Time Duration]))
The result from the two formuls are working but then noticed the following:
The two records below should both calculate to 100 hours but the first one does not.
BegDate EndDate Hours
01-13-2018 08:01 01-17-2018 12:00 99 (should be 100 hrs)
01-13-2018 08:01 01-17-2018 12:01 100
The two records below should both calculate to 100 hours but the first one does not.
BegDate EndDate Hours
01-13-2018 08:01 01-17-2018 12:00 99 (should be 100 hrs)
01-13-2018 08:01 01-17-2018 12:01 100
