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) ?
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!
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!