Subtracting date and time
I am working on a delivery smartsheet, where I need to figure out how long it takes to get a product from the order phase, to the parts picked to the delivered phase.
Here is a screenshot of how our times are formatted, these can be over multiple days and not just a single 24 hour period. I looked through other posts to see if there were similar issues that had been answered, I did not see any, was curious if there was any formulas out there that I could modify to fit my data.
Thanks
Comments
-
Basically you will need to break apart the date from the time. From there figuring out how many days is simple. For the time... You will want to break out the hours from the minutes from the AM/PM. Convert the hours to minutes, add the minutes, find your difference, then put everything back together in the format you are wanting to display it in.
Or....
There are some rumors of time calculations becoming available sometime in 2019. If you can wait on them that is.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
That sounds like quite the formula, do we have any guestimate of how long or when this will be available? Or is this just simply rumors?
-
I am working on putting it all together into an easy to read sheet that I can publish. Once I get it wrapped up and all of the bugs worked out, I'll post a link here. May not be for another week though as I am pretty busy today and won't be logging back on until Wednesday of next week.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you very much!
-
Hi,
I think they will release it at this years Engage conference in Sep-Oct.
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Which time differences were you wanting to calculate?
Order --> Pick
Pick --> Shipped
Order --> Shipped
Other?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!