I want to convert to HH:MM, but I always get HH:MM:SS
Here’s my formula:
TEXT({Duration (Decimal hours)}*3600,“HH:MM”)
This is the result:
What am I doing wrong?
I want to convert to HH:MM, but I always get HH:MM:SS
Here’s my formula:
TEXT({Duration (Decimal hours)}*3600,“HH:MM”)
This is the result:
What am I doing wrong?
It’s not you.
Here’s two answers:
LEFT(RIGHT(" "&TEXT({Duration (Decimal hours)}*3600,"HH:MM"),8),5)
REGEXEXTRACT(TEXT({Duration (Decimal hours)}*3600,"HH:MM"),"(.*):00")
Jim - Subscribe to The Monday Man
Watch Our Latest Video: Quick Tip - The Trick to Editing Custom Automations
Thanks Jim.
Sense like they would differentiate between HHMM and HHMMSS in a function like this.
Scott
Can I do the opposite? Convert from HH:MM to a decimal hours?
If you are referring to an “Hour” column, this will do it:
TIMEVALUE("1/1/1 " & {Hour}) * 24
Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: A Status Column Tip - When is “Done” really DONE?
Contact me directly here: Contact – The Monday Man
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.