2 of 2 people found this helpful
First Convert your time to seconds:
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.
Thank you so much, you are a life saver !!!
Enjoy your weekend.
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 ?
Thanks in advance for your help,