Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Time formatting
How can i get Smartsheet to recognise time format i.e. 7:30am & 17:45pm and also to be able to calculate the total hours?
Comments
-
Hi M2 - Currently, time formatting and calculating hours based on timestamps isn't supported in Smartsheet. This is on our enhancement request list though, and I've added your vote for it. Thank you for your input!
-
M2,
Here's a long thread about time:
Craig
-
This is a simple request ... input time started and time finished and calculate the time taken ... to me, an absolute necessity.
-
Yes, we need the time format please. It seems the query has been raised since 2015. Looking forward to this enhancement.
-
I vote for that . please add the time format.
-
Any update to the time formatting enhancement??? It looks like it's been a couple years in the making now...
-
Still hoping this enhancement is implemented.
-
Really would like to see Time Stamp and/or Time Formatting, per the rest of this thread. Please add a vote on this topic for me.
Thanks,
Mike
-
please add my vote to this as well.
-
Please add my vote to the feature request for time formatting (especially if it could visible on the calendar view).
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending Posts
- Hi! I cannot figure this out. I have a "% Complete" column (0, 25, 50, 75, 90, 100, Cancelled). I made a simple checkbox column that should be checked if the item's "% Complete" value is equal to anyt…
- This formula keeps coming up as #UNPARSEABLE. I have checked the name of the columns, they are correct. Any ideas? I am trying to show the days remaining in a project. =IF([% Complete]@row = 1, "", NE…
- Hi All! I´m trying to find the error in this formula but have not been able to find the solution after many attempts. Any ideas? =IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF(…