I gather when you say "0-6=.1" you mean 0-6 *minutes*. And, I assume the boat
came in after it went out. If so, the following should work:

=min(roundup((datein+timein-dateout-timeout)*24,1),2)

--
Regards,
Fred


"relaing" wrote in
message ...

Hope someone is able to help.
This is to calculate the chargeable hours for a SAR boat in the water

Date In| Time In| Date Out| Time Out|Conversion Time| Total

Conversion time is value of ((DateOut+TimeOut)-(DateIn+TimeIn)*24) but
needs to be rounded up to the nearest 0.1 i.e. 0-6=.1, 7-12=.2,
13-18=.3 etc. with a minimum chargeable time of 2 hours.

Have tried ROUNDUP and CEILING but obviously not the correct way!

Thanks
Rick


--
relaing
------------------------------------------------------------------------
relaing's Profile:
http://www.excelforum.com/member.php...o&userid=29355
View this thread: http://www.excelforum.com/showthread...hreadid=490647