Calculating difference between Timestamps

[stsithelpdesk]

I have a sheet which is time tracking tasks, we have a task generation timestamp, a "started task" timestamp and a "completed task" timestamp. I then have columns for calculating the difference between these timestamps. Generation > Started, Started > Completed and Generation > Completed. Where generation, started and completion all occur within the same day the calculations are working fine but when the time taken exceeds 24 hours the counter resets.

I think I can get the answers I want from splitting out the Days, Hours and Minutes and then combining the results in a further cell but I wondered if anyone can help me achieve this with a single formula?

Thanks!

 

[HighAndWilder]

I have a sheet which is time tracking tasks, we have a task generation timestamp, a "started task" timestamp and a "completed task" timestamp. I then have columns for calculating the difference between these timestamps. Generation > Started, Started > Completed and Generation > Completed. Where generation, started and completion all occur within the same day the calculations are working fine but when the time taken exceeds 24 hours the counter resets.

View attachment 102075

I think I can get the answers I want from splitting out the Days, Hours and Minutes and then combining the results in a further cell but I wondered if anyone can help me achieve this with a single formula?

Thanks!

Use a custom format of [h]:mm:ss