time formula

Hello,
I need some help:
In cell A1 (let's say) we introduced the time: 10: 00 PM, in cell B1 we entered 5:40 AM.
in cell C1, I need to calculate the difference between A1 and B1, and the result is displayed as number - it should be 7.67 hours worked.
Can someone help me?

You can use this in C1:

=(B1-A1+(A1>B1))*24

to give the result as decimal hours.

Hope this helps.

Pete

Or try:

MOD(B1-A1,1)*24

Thx. Both solution work.