Subtract Hours in Smartsheet
Is there a way in Smartsheet, like in Excel, that you can subtract hours and convert PM to AM? I have a "KO time" column, and a "Start Time" column, and I am wanting to subtract 5 hours from the KO time column to have my "Start Time".
The formula I have in excel does not work in smartsheets (="KO Time"-(5/24)) and I am trying to migrate this sheet from excel to smartsheets
Answers
-
Smartsheet handles time poorly. There have been requests for at least six years for features that allow you to work with time as well as date. I can tell you how to write the formula, but it's not going to do much good if you can't display the time. However, in case you're exporting back out to Excel, you would write the formula basically as you have it, but your syntax is slightly off. It would be:
=[KO Time]@row-5/24
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 151 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!