Hello, is it possible to configure a date type column to show the time (hour:min)?

Produccion CI

I would like to schedule activities into specific hours of the day.

 

Thanks.

Brett Evans

Here is my attempt

 

 https://app.smartsheet.com/b/publish?EQBCT=19e517036f1f4efe9553c9e0c75b9824

Produccion CI

Thank you very much Brett!, this is part of my problem, the next part is how to block certain day/time window when adding a new task, for example my first task is 01/01/2016 @ 8:00 a.m. and finishes 01/01/2016 10:00 a.m., if i need to add a second task for the same day, then i should be allowed to schedule from 10:00 a.m. to the end of the day, is there a way to do that.

 

Thank you again.

Brett Evans

That seems possible.  

In one coulumn, you would have to use a set of nested match/lookup functions to find the time and date with the key match value being the date in your row,  This would allow you to see the time range you have available.

 

Then you would need to do some conditional formatting based on the time entered in your new  row and use the value returned above to see if your value is valid based on your criteria.

 

Although it seems possible, it also seems like it would take many hours to days to get right.  Good luck!

Produccion CI

Thank you very much, i appreciate your help.