Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Excel Duration - Transforms to different types

I'm buiding some reporting based on Excel files, these will be dropped in a folder monthly. I have the first months data, I usually just copy that file a couple of times to simulate multiple months o...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , keep your time in second and use Dynamic FOrmatting to handle this

 

Time format

"""" & QUOTIENT([net time],3600) & ":" & QUOTIENT(mod([net time],3600),60) & ":" & round(mod(mod([net time],3600),60),0) & """"