HH:MM calculation in Smartsheet
I need to do a time motion study of a process, so will use HH:MM format to get total time in minutes, I am finding it difficult in smartsheet, could you please help me how can I easily subtract Start time and finish time to get total time…
I searched on smartsheet community, on this link : https://community.smartsheet.com/discussion/44746/time-formats-number-formats-rethinking-the-ux-and-function
I got one formula : =VALUE([Start Hr]2@row) + (VALUE([Start Min]2@row) / 60)
But I am getting #unparseble error.
Ex.
https://us.v-cdn.net/6031209/uploads/45B1IZAWULRS/capture-png.png