Create Date - Modified Date= Time Spent ERROR

This discussion was created from comments split from: Create Date - Modified Date= Time Spent.

Answers

  • @Leibel S / @Paul Newcome

    Hello! I am trying this solution and getting an #INVALID OPERATION error at the duration in minutes column.

    I was hoping someone could help me out and see what went wrong.

    Both Created Date & End Date are Date type columns.

  • @Alyssa_OBrien

    This is what I did for mine and it works. My Start Time and End Time are in hours.


    =((VALUE(LEFT([End Time]@row, FIND(":", [End Time]@row) - 1)) + VALUE(RIGHT([End Time]@row, 2)) / 60) + ([End Date]@row - [Start Date]@row) * 24) - (VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) + VALUE(RIGHT([Start Time]@row, 2)) / 60)

    Hope this helps.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!