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:[email protected]  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.

@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), "")

@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.
Help Article Resources
Categories
Check out the Formula Handbook template!