Try one of these:

=IF(COUNT(D3:E3)=2,E3-D3,"")

If the end time might span past midnight:

=IF(COUNT(D3:E3)=2,MOD(E3-D3,1),"")

Format as h:mm

--
Biff
Microsoft Excel MVP


"Matt" wrote in message
...
In cell F3 I am trying to get the hours work from the start time in cell
D3
and the finish time in E3. I can not locate the forulma for this?