How to auto populate time in a table on sharepoint (and can edit)

Question

Hi,

I have a calculated column - Calculated (calculation based on other columns) - with the below formula inputted to auto-display the time:

=TEXT([Serial Start Date/Start Time],"hh:mm")

However, I noticed this makes the cells on Sharepoint 'read-only' - so I can't make edits to the time if I wanted to change something.

Is there a better formula to use where I could get the time to be auto-populated (based on a previous 'Date & Time' column), but still be able to make manual changes to contents in this cell? (without the time being altered from the original Date & Time Column which the information is being extrapolated from).

Thank you!

Answer 1

Hi @annonnon
Per my research, the column with formula could not be edited manually. The value of it is depended on the calculated formula.

For example, I set the "add" column formula as 1+2, then the value could only depend on column "1" and column "2", which is read only.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Go to List settings -> Advanced Settings and Select Allow management of content type then press Ok. , and click in the _hidden column. Set the column setting to Hidden and click Ok.