Hello again Ben,

You need the following formula in column D:

=(B1-A1)*24

You will need to format the result cells to be General formats not
dates. To do the highlight all the expected results cells for column D
and hold Ctrl + Shift and press #. This will set the cells to General
formatting.

If you also want different colours you will also need Conditional
Formatting:

Highlight the results cells in column D and choose Format + Conditional
Formatting.

Change the Between text to Greater than 0 and click the Format button -
choose grenn.
Click the Add button. Change the Between text to Less than 0 and choose
the second Format button - choose Green.

Post again with any problems

Judith


--
JudithJubilee
------------------------------------------------------------------------
JudithJubilee's Profile: http://www.excelforum.com/member.php...fo&userid=6882
View this thread: http://www.excelforum.com/showthread...hreadid=519160