If statement with time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

Brain totally befuddled, please help

I'm trying to set up a timesheet. As long as everyone takes the standard 30
minute (or over) break it's fine. I just calculate the time worked in the
morning and the tiem worked in the afternoon and add them together.

My problem is where less than this time is worked

B1 = A3-A2
B4 = A5- A4
B6 = B4+ B2

C4 = A4 – A3 = actual lunchbreak

Times are formatted hh:mm

Can anyone show me how to use an IF statement that puts in 30 minutes as
lunchbreak where less than 30 minutes.

Having a stressful day and really can’t get my head around it
 
One formula

=A5-A2-MAX(A4-A3,TIME(0,30,0))

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thank you!!! :-)
--
Smudge


Bob Phillips said:
One formula

=A5-A2-MAX(A4-A3,TIME(0,30,0))

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
Back
Top