View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] cjthiart@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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