Paul Sheppard Wrote:
Hi Helen
..............
E2 =SUM((B2-A2)+(D2-C2))

Format cells as Custom hh:mm

Paul's formula will sort of return the number of hours worked.
However, in the hh:mm format, it is actually shown as a time, such as
08:00 a.m.. It is difficult to do further calculations (e.g. pay
calcs). You could format E2 as General and use this formula to return
the actual number of hours worked:

E2 =((B2-A2)+(D2-C2))*24 {the SUM function is not needed}

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=467523