=int((B1-A1)*24)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Connie" wrote in message
...
I need a formula or function that will calculate the number of hours
between
11:00 am and 4:00 pm = 5 hours.

Thanks, Connie Smith