Formulas for Calculating Time
Comments
-
@Andrew Stills I usually use something that will give me "yyyymmddhhmm" as a value (hh is in 24 hour format). Runs into the same limitation when multiple rows are created within the same minute but doesn't require the time zone conversion for the YEARDAY function.
=VALUE(YEAR(Created@row) + "" + RIGHT("0" + MONTH(Created@row), 2) + RIGHT("0" + DAY(Created@row), 2) + LEFT(TIME(RIGHT(Created@row, 8), 1), 2) + RIGHT(TIME(RIGHT(Created@row, 8), 1), 2))
-
Oh that's great and bit shorter… er, more elegant. Would also allow it to survive past 2099. There goes my plans to start Y2.1K! ;-)
Thanks for passing it along, @Paul Newcome.
Andrew
He who fails to plan is planning to fail. - Winston Churchill
-
Welcome to 2025!
From 2020 to 2025, this has gotta be the longest thread we have in smartsheet. 🤣
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.4K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 492 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives