Calculating hours between 2 dates/times

[CaraM]

This is supposed to be an easy "subtract the earlier from the later" formula, but it's not working, for me.

If I want to calculate the HOURS between Sunday 3/9/2025 at 8am and Wednesday 3/12/2025 at 8PM (first date/time in cell A1, 2nd in cell B1), the interwebs tell me my formula should be =B1-A1.

When I use this formula, my result is 12 (when formatted as "h"). That's not right. What am I doing wrong?

If my B1=3/10/2025 8:00 AM, the result is 0!

Book2
	A	B
1	3/9/25 8:00 AM
2	3/12/25 8:00 PM	12
Sheet1

Cell Formulas
Range	Formula
B2	B2	=A2-A1

 

[Fluff]

Format the cell as [h] rather than h

 

[CaraM]

Format the cell as [h] rather than h

Well, that worked perfectly. I've used Excel for decades but don't know - what's the difference between [h] and h ?

 

[Fluff]

[h] is the total hours whereas h gives hours in a single day.