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