If statement to work out time/overtime
Hi guys, I am having trouble with a formula if anybody can help please.
I have two cells A1 & B1 that holds start time and end time of work done. I then have another two cells C1 & D1. C1 is normal hours worked and D1 is overtime. I am looking for two formula's. For example lets use below data:
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"
Ive been running around with If, And and subrtracting MAX statements but cant find one that works. Please help!
Conrad
|