4 Replies Latest reply on Dec 6, 2018 3:51 AM by Ombir Rathee

# Sum up hours over 24 hours

Hello,

I need your help, I have been trying to sum up these hours (see excel file attached) but it does not display over 24 hours.

I should have a total of 915:01:11 instead of 03:01:11.

Any ideas ?

• ###### 1. Re: Sum up hours over 24 hours

First Convert your time to seconds:

SUM(INT(MID(STR([Volume hms]),12,2))*3600)+

SUM(INT(MID(STR([Volume hms]),15,2))*60)+

SUM(INT(RIGHT(STR([Volume hms]),2)))

Then Convert to HHHH:MM:SS using below field.

IIF([Seconds] % 60 == 60,0,[Seconds] % 60)

+ IIF(INT([Seconds]/60) %60 == 60, 0, INT([Seconds]/60) %60) * 100

+ INT([Seconds]/3600) * 10000

Finally change the Number Format to ####:##:##

Hope this helps.

2 of 2 people found this helpful
• ###### 2. Re: Sum up hours over 24 hours

Thank you so much, you are a life saver !!!

Best,

B

• ###### 3. Re: Sum up hours over 24 hours

Hello Ombir Rathee,

hope you are alright.

I have recently changed my datasource from excel to MySql and the HH:mm:ss calculation is no longer working well.

Now instead of 02:58:50 I get 01:76:50

How can I change that ?