Discussions
Categories
Groups
Forums
Board Platform Discussions
Board Academy Discussions
Product
BOARD PRODUCT
BOARD FORESIGHT
BOARD KNOWLEDGE BASE
Connect
Blog
Customer Success Hub
Board Advocacy Program
Community Captains
UX Research
Recordings & Replays
Groups Hub
Training
Board Academy
Course Catalog
Academy Forum
Employee Learning
Idea Exchange
Partner Hub
NEWS & VIEWS
RESOURCES
CONNECT
Support
FIND ANSWERS
TAKE ACTION
Blog
Home
Forums
Platform
transform seconds into hh: mm: ss format
Massimo Palmi
Hi all!
I' d like to have some advice...
I have a layout with a
column where I dynamically calculate the number of seconds and where I drill this information from month to day, I'd like to show this information in the hh:mm:ss format, any advice?
Thanks!
Massimo
------------------------------
Massimo Palmi
Consulente
RETEX SPA
Italy
------------------------------
Find more posts tagged with
Accepted answers
All comments
Johannes Blischke
Hi
@Massimo Palmi
,
let's say your seconds block is "a". You need 4 more blocks in your layout:
b = (a-(mod(a,3600)))/3600 --> returns your hours
c = (mod(a,3600)-mod(b,60))/60 --> returns your minutes
d = mod(b,60) --> returns your seconds
e = b&":"&c&":"&d
Thanks to
@Sebastian Gurt
, the solution was found through teamwork.
Best regards
Johannes
------------------------------
Johannes Blischke
Consultant
Board Community
Germany
------------------------------
-------------------------------------------
Massimo Palmi
thanks for the valuable advice!
Best regards!
------------------------------
Massimo Palmi
Consulente
RETEX SPA
Italy
------------------------------
-------------------------------------------
Quick Links
📢 Community Guides
📘 Board Knowledge Base
⭐ Best Practices
✍ Community Experience Survey
📑 My Bookmarks
💬 My Discussions
🤝 Groups