Time elapsed formula needed

[Noxqss38242]

In cell B2 I have a date/time 11/28/2023 6:07
In cell C1 I have today's current date/time 12/1/2023 9:18

I'm wanting a formula that tells me how much time has past in hours only.
But when I do =text(c1-b2,"H") it gives me 3 hours.
YET, it should be like 75 hours?

What should the formula be to track all hours that have passed?

 

[Fluff]

How about

=TEXT(C1-B2,"[h]")

 

[shaowu459]

工作簿1
	A	B	C	D	E
1			2023-12-1 9:18
2		2023-11-28 6:07		75
3
Sheet1

Cell Formulas
Range	Formula
D2	D2	=INT((C1-B2)*24)