Hi Conrad,

Am Tue, 30 Jun 2015 00:27:34 -0700 (PDT) schrieb :

A1 B1
05:00 19:00

C1 should work out the time between 08:00 and 17:00 and display "09:00" hours

D1 should work out overtime, (hours worked before 08:00 and after 17:00) and display "05:00"

in C1:
=TIME(17,,)-TIME(8,,)
in D1:
=B1-A1-C1


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional