New Contributor

I want to know if it´s possible to calculate (to subtract, in fact) two different hours (Arrival and departure) in the same cell, and then sum up this with others cells from other days. I don´t know if you guys understand what I mean.

This is the example:


Monday             Tuesday                 Wednesday          total hours

13:00 - 18:30       11:00 - 20:30         15:00 - 0:00             ???


Thanks in advance!!!!



2 Replies
best response confirmed by JuanAros (New Contributor)


Let's say the times are in A2:C2.

Enter the following formula in D2. If you are NOT using Excel in Microsoft 365 or Excel 2021, confirm the formula with Ctrl+Shift+Enter.




Format D2 with the custom number format [h]:mm

Fill down if required.


It works perfectly, thanks a lot mate!