I need to inout the hours in that format, so text doesn’t work, number entry wouldn’t work the closest thing to what I need is the duration column with a text entry where i have to manually write 00:15 if I want to input something similar but that takes the information in days not hours and I can’t convert it in the backend.
How do you intend to use the time if you could enter it? Nothing in Glide can store a time on it’s own, so that’s why I ask. Depending on your use case, you would maybe need to use a text entry and then use a javascript column to turn it into a meaningful number.
I’m building a Time Tracker and the client wants the option to just input the time, I had a number entry to input hours as decimals but they aren’t happy with that they asked for the ability to insert time as hh:mm
Right, but how are you using it. Are you doing some math with it? Merging with a date? Just displaying it as is? I’m trying to understand what is supposed to happen with that time once it’s entered. You can just type it in a text entry but you say that doesn’t work without explaining why. So if you plan to do something with that value other than just displaying it, it would help to understand the final goal once it’s entered.
What Jeff said 
I assume he wants to add the times to a date.
I think what I would do is create a custom component with an entry that forces the formatting ‘:’ so it’s automatically included when typing. Then have the component convert and write the time is decimal format to the table.
Kind of what I’m doing here. The ‘:’ is part of the entry, so it can’t be erased. The entry only accepts numbers. I’m not doing any conversions because the time math is all internal to the component and ultimately stores in a JSON object.
The other thought is to use a standard text entry for input, and then use a javascript column to convert the entry into a time in decimal format.
With the decimal time format, it can be added to an existing date with a math column.
Yeah, custom component is good for this.