Wednesday, 21 December 2022

Excel - Subtract two time stamp columns/rows

Formula

=TEXT(A70-A69, "h:mm:ss")

Other samples,

Calculate hours between two times: 

=TEXT(B2-A2, "h")

Return hours and minutes between 2 times: 

=TEXT(B2-A2, "h:mm")

Return hours, minutes and seconds between 2 times: 

=TEXT(B2-A2, "h:mm:ss")

No comments:

Kiro - Core Features

What is Kiro Kiro is an innovative AI-powered IDE that revolutionizes software development through intelligent assistance and structured wor...