How do I take two recorded times and write a Microsoft Excel formula that calculates the total time?

Basically have starting point and stop times recorded in a Microsoft Excel in life Spreadsheet, how to create some sort of formula this calculates the quantity of time between the beginning and end times

A1 will be start, B1 is finish, C1 =IF(A1>B1, (1+B1)-A1, B1-A1) data format the cell as they would:mm
To amount a compilation of times just make use of the SUM perform but format the actual result cell when using the above format.

Take the 2 times, select the 2 cells they’re just in.Check out SUM from the list involving functions.It provide you with the overall.