Function or Formula that returns current Time ( without the date )

Any formula or function that can return the current time ( in IST) without the date .

Now()+5.5/24 will return the current time along with date (in IST) . How can i return only the current time (in HH:MM) ?

Hi @Renj-154a, thanks for your question here! :slight_smile: :honeybee:

You can return only the time by formatting the column or field to Time (rather than Date & Time).

If it's in a table, you'll want to change the format in the column properties:

If in an app, change the format of the data cell:

Hope that helps, and let us know if you have any other questions! :honey_pot: