What's up with HH:MM format?

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?

This topic has been closed for replies.

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")

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

A

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

Sign up