Hi!

Try this:

=(B6-A6+(B6<A6))*24

Copy down as needed.

Returns:

4.5
8
15.9833333333333

Biff

"evon" wrote in message
...
3 situations would be as follow, i set the formular like this is =IF(B1<A1,
24/24-A6+B6,B6-A6), both A & B using time format and C using number
format.

A B C
Start Time End Time No. of hours
10:30 15:00 4.5
00:00 08:00 8.0
08:00 23:59 16.0 **Problem**

I can get the result for the first 2, but not the last one, any one can
help, many thanks!