Get Total Duration from Date Time in different format

Hi friends :wave:,

You can calculate the total duration between start and end date time

For example, you may input formula script as shown below pictures:

image

In the formula script, insert (field(‘End’) – field(‘Start’)).TotalDays to get the total days

Make sure the result field must be in type “text”

image

Other format you can get such as in timestamp, days, hours, or seconds

3 Likes