Create Date - Modified Date= Time Spent ERROR

System

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

Alyssa_OBrien

@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.

MSGFreebird

@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.