Simple hour vs day formula

[sassriverrat]

Good Evening,

I have a formula here that calculates the time difference from one date to another. It should spit this back in whole hours and it does. However, if I go over 23 hours (i.e. noon to noon), it goes back to zero because I think it's taking out a day. I need it to be able to hit 24+ hours. How might I fix this?

Note:
D4 is a time (both the active and the previous sheet)
F4 is a date (both the active and the previous sheet)

 

[steve the fish]

Thats not true mole. As far as i can tell he wants the number of hours as an integer ie 1 = 1 hour. If it was formatted as time then 1 = 1 day.

 

[sassriverrat]

@mole999 and @steve the fish

Is there a notable positive of having my original formula versus not having the "hour" piece? I can't remember why I threw the "hour" piece in there- but when I wrote the workbook last year there was a ton of experimenting....so I would have had a reason I suppose

 

[steve the fish]

HOUR can never go over 23. So HOUR(0.01) produces the same number as HOUR(1.01). If you want to go over 23 hours then use what i suggested in multiplying the formula by 24. 24*1.01 can clearly go over 24.

 

[sassriverrat]

Thank you gentlemen! and yes, I'd like it to be able to go over 24