Time Indication and DATEONLY function
I have a few questions below regarding Smartsheet:
- We're utilizing Smartsheet to track start time and end time in a 24-hour clock to count the duration of some of the tasks we complete.
- How can I remove the time in "Created", I would only like to have the date. (photo 2)
Question 1 Explanation below:
I've noticed some of our front line staff will input times like "0412 or 0420" indicating 4:20 am. However, the Smartsheet won't register this number as 0412 or 0420 but as 412 or 420. Is there a way to make sure the time shows 0412 or 0420 and not 412 or 420?
Help Article Resources
Check out the Formula Handbook template!