Calculating time elapsed in Hours/Min/Secs between two periods

[itsmeemilie]

Hi,
I need to calculate the rest time between the end of a shift and the begining of the next one.
What formula would I need to use to calculate the elapsed amount of hours/mins between C2 and B3?

 

[6StringJazzer]

=B3-C2

Format as hh:mm

 

[itsmeemilie]

=B3-C2

Format as hh:mm

it works until I jump a full day between shifts.
It doesn't calculate the 24hr for the 24th of October.

 

[6StringJazzer]

Use a custom format of [h]:mm to show more than 24 hours.

 

[Chechel]

=INT(C2-B2)&" days "&TEXT(C2-B2,"h"" hrs ""m"" mins ""s"" secs""")

 

[6StringJazzer]

The OP asks for hours/mins, not days.

$scratch.xlsm
	A	B	C	D
1			10/23/2022 19:00
2		10/25/2022 6:30		35:30
Sheet11

Cell Formulas
Range	Formula
D2	D2	=B2-C1

Custom format [h]:mm