Forum Academy Marketplace Showcase Pricing Features

How to get the duration of Date Range?

Question
#1

I can’t seem to find a way to find the duration of a date range, in this case as hours. I would think that a given.

Is there a way to calculate the duration?

Thank you!
Benjamin

#2

If you use two separate data fields, you can subtract the second from the first and then format it as hours. Not too sure about data range fields, though…

Tal

#3

A date range is made of a start date and a end date, so I think you can subtract the first one to the second one as explained by Tal

#4

Thank you for helping. I guess I should have specified, how do I get duration as a function so that I can sum the durations for more than one date range?

I counts how many there are, but not how long they are summed.

Here is my trying to say it verbally, that might be easier: https://www.loom.com/share/0c2657f117184d239c2a629cb5740d45

Any ideas?
Thank you!

#5

Hello,
Did you find an answer ?
Thanks

#6

@skuigi I hired someone to build it for me… Sorry!

1 Like
#7

Thanks for the answer.
By the way I solved it by sotring the duration in a data type :wink:

1 Like