SUM the minutes and seconds and show in mm:ss

[dmohanty]

Hi All,

I have a data field like this below. I want to show the SUM of this field and the result should be in mm:ss format. How to SUM this?

00:05

00:06

00:34

00:38

00:39

1:39

00:02

00:03

00:04

00:07

00:08

00:09

00:10

[dmohanty]

Hi All,

Any help here please!

[Anonymous]

Use the Interval() function.

For example, this script,

load * Inline [
    ElapsedTime
    00:30
    00:28
    00:05];

with this function,

=interval(sum(ElapsedTime),'mm:ss')

will yield 63:00.

[dmohanty]

In the expression the above Calculation is showing 00:00 every time.

[ziadm]

Hi

interval(sum(TimeSpent),'hh:mm:ss')

missing hours format hh

this should be ok

Regards

Ziad

[dmohanty]

This has not helped either.

Is it because I have some other dimensions as well?

[jagan · Accepted solution]

Hi,

Try this script

load *,

TimeStamp#(ElapsedTime, 'hh:mm') AS Time_Format

Inline [

    ElapsedTime

    00:30

    00:28

    00:05];

and in front end use this expression

=Timestamp(Sum(Time_Format), 'hh:mm')

Hope this helps you.

Regards,

Jagan.

[MK_QSL]

=Interval(SUM(Time#(TimeField,'h:mm')),'hh:mm')

[ankitaag]

Hello,

Write the expression as

=Sum(Timestamp(ElapsedTime,'hh:mm'))

Thanks and Regards,

Ankita

[dmohanty]

Thank you Jagan.

This has worked.