What's the problem?
4.5
8
15.98333
is what I get using
=(B1-A1+(A1B1))*24
are you saying that you want to round, if so what's the rounding criteria?
Nearest .25 using decimal hours? If so
=ROUND((B1-A1+(A1B1))*24/0.25,0)*0.25
will return 16
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"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!