Calculate amount of hours between dates and times
Hello,
Can anyone help me calculate the amount of hours and minutes between dates and times? I have tried numerous formulas but none are working for me. Is there any particular format the time column needs to be?
Appreciate anyone's help with this, thank you.
Leah
Answers
-
It might take a little bit of digging (up to 14 pages at this point), but there should be something tucked away in here for you:
-
Thank you very much, that is helpful.
this one is working for me, only thing is i want it to include working hours only, is this possible?
-
@Paul Newcome can you offer any help on the above?
Thank you
-
Time is so frustrating... I wish I had something to help! I can share this to Vote on for feature requests.
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
-
Thanks! @Joe Goetschel
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!