Calculating & Converting elapsed time result to a total minutes result

Platform discussions
, , ,
1

Hello, I am working on a time tracking board and need to have the “Total Elapsed Time” for certain group total in the footer.

The formula I have to calculate the elapsed time shows a message in the footer that it requires a numeric value to total. Is there a way to modify the formula so it will be able to calculate, is there a formula to calculate the elapsed time only in minutes so that can total, or another suggested way to get that total time in the footer for the group?

The Start & End Time columns are HOUR columns, the Elapsed Time is a FORMULA with this formula: HOURS_DIFF({End Time}, {Start Time})

I need to convert this to something that will total. If I use the following formula it only calculated the whole hours in minutes, but does not include the remaining minutes.
Total Minutes formula: HOURS_DIFF({End Time}, {Start Time}) * 60

When I try to add any reference or use the AI assistant to add in the remain minutes, the column shows an error.

I have tried a couple of formulas I found in the community, with no success. Any help or suggestions would be greatly appreciated.
Thanks

image
image564×362 16.6 KB

2

@AshleyW

Here you go:

SUM(
  MULTIPLY(
    LEFT(
      HOURS_DIFF(
        {End Time},
        {Start Time}
      ),
      2
    ),
    60
  ),
  RIGHT(
    HOURS_DIFF(
      {End Time},
      {Start Time}
    ),
    2
  )
)

There might be a simpler way of doing it but this certainly works. Your clear explanation helped a lot too!