Hours between two dates

[JTL9161]

I have these dates and time

(P16) 8/22/24 5:23 AM (S16) 08/23/24 5:18pm I am trying to just calculate total hours between the 2 dates. I tried =TEXT(S16-P16,"h") but I get a #VALUE! error. Any help would be appreciated. James

 

[myall_blues]

=(S16-P16)*24

 

[MARK858]

Try putting a space between the 8 and the pm in 08/23/24 5:18pm

Your formula also needs some [] or use the formula by @myall_blues formatted to suit

=--TEXT(S16-P16,"[h]")

 

[myall_blues]

Try putting a space between the 8 and the pm in 08/23/24 5:18pm

Well spotted.

 

[JTL9161]

Dang Space! Thanks

 

[MARK858]

You're welcome, happy we could help