LinkBack URL
About LinkBacks
badger 
formula should be
A1 B1 C1 D1 E1
start end lunchstart lunch end answer
9:00 12:00 11:45 12:15 2:45
format the formulae cell as time
formulae is
=IF(C1>B1,B1-A1,IF(AND(C1<B1,D1>B1),B1-A1-(D1-B1),B1-A1-(D1-C1)))
formula should be
A1 B1 C1 D1 E1
start end lunchstart lunch end answer
9:00 12:00 11:45 12:15 2:45
format the formulae cell as time
formulae is
=IF(C1>B1,B1-A1,IF(AND(C1<B1,D1>B1),B1-A1-(D1-B1),B1-A1-(D1-C1)))
Last edited by anilsolipuram; 06-26-2005 at 10:28 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks