Show 'time' only in 'date' field such as '17:56' instead of '2020/12/15 17:56'

Is it possible?

I need the timestamp feature that I can record the current time just with one or two click(s)
but still can be modified manullay.

I use ‘date’ field for this purpose but it displays date that I dont’t need.
Duration field shows only time but it does not support one-click current time insertion.

The only work-around I found is
Column A: date field: 2020/12/15 17:56
Column B: formula filed: DATETIME_FORMAT(‘Column A’, ‘hh:mm’)

There are two problems.

  1. I have to use two columns to show only one field
  2. Column B has a timezone issue.
    (I live in UTC+9 area. The column A has a local time but column B shows UTC time.
    So A is 2020/12/15 17:56, but B is 08:56

Thanks.

You are correct about all of your options.

You can use the SET_TIMEZONE function in your formula field, like this:

DATETIME_FORMAT(
SET_TIMEZONE({Column A},'America/Los_Angeles'),
'hh:mm')

For an even deeper dive into time zones, you can check out my sample base & training video here:

I appreciate your comment. It needs to create one more field. One for the timestamp itself which shows date and time, and another formula field to show time only…

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