Tracking time
Comments

Hi Michelle,
Yes, there is. It depends on how your solution is setup. Can you share the solution or upload some screenshots?
I hope this helps you!
Best,
Andrée Starå  Workflow Consultant @ Get Done
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.

Keep in mind... Tracking time in Smartsheet only works for days. Smartsheet cannot handle actual times (hours/minutes) without rather convoluted workarounds.
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!

@Paul Newcome Is this still the case and l need a convoluted workaround to get how much time a generator was running?
Trying to calculate how many hours a generator run for, and for the cell to show as empty when there's no data in the cells. After reading a lot of posts came up with a formula but l can't figure out how to remove the "#INVALID VALUE" error, tried wrapping the formula in a "IF ERROR" but did not work.
This is my current formula, but there has to be something simpler and that allows for a cell to show as blank if both feeding cells are blank:
=VALUE(LEFT([Generator #2 Time Stopped]@row, (FIND(":", [Generator #2 Time Started]@row)  1)))  VALUE(LEFT([Generator #2 Time Stopped]@row, (FIND(":", [Generator #2 Time Stopped]@row)  1))) + (VALUE(RIGHT([Generator #2 Time Started]@row, (FIND(":", [Generator #2 Time Stopped]@row)  1)))  VALUE(RIGHT([Generator #2 Time Stopped]@row, (FIND(":", [Generator #2 Time Stopped]@row)  1))) / 60)
Screenshot of the sheet:
Thanks!

@Silvia Rangel That is correct. Smartsheet does not yet have built in time calculations. I will include a link at the bottom of this post to a thread that has numerous time based solutions in it.
As for the IFERROR, it should wrap around the entire formula like so...
=IFERROR(VALUE(LEFT([Generator #2 Time Stopped]@row, (FIND(":", [Generator #2 Time Started]@row)  1)))  VALUE(LEFT([Generator #2 Time Stopped]@row, (FIND(":", [Generator #2 Time Stopped]@row)  1))) + (VALUE(RIGHT([Generator #2 Time Started]@row, (FIND(":", [Generator #2 Time Stopped]@row)  1)))  VALUE(RIGHT([Generator #2 Time Stopped]@row, (FIND(":", [Generator #2 Time Stopped]@row)  1))) / 60), "")
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!

@Paul Newcome Thanks! So, l realized l had a space between the end of the formula and the coma
( 60)
, "") and this was giving me the error... Also, l tried the formulas in your ime based solutions post but none worked for what l am looking to do, at least for this sheet, as they worked for others! ☺ 
@Silvia Rangel Glad you got that figured out. Are you still needing an overall formula? I would imagine a negative result for run time is not exactly accurate.
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
 438 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 451 Show & Tell
 30 Member Spotlight
 1 SmartStories
 282 Events
 32 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!