If start time is in A1 and end time in B1 then to show the number of
hours worked minus 30 minutes

=MOD(B1-A1,1)-"00:30"

format as h:mm


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=524613