Calculating hours

  • Thread starter Thread starter Debbie Dies
  • Start date Start date
D

Debbie Dies

I have been trying to subtract out regular hours from overtime hours.
can't seem to get it to come up with 8 reg hours.

cell a1 = 8:00 am
cell b1 = 10:00 pm
cell c1 = b1-a1 answer 14
cell d1 =???? I want it to say 8 hrs if c1 is over 8 hrs and if c1 is
hrs or under I want it to = c1.

So long has I am not using time format I can get this to work. But a
soon has I use time format it won't work.

Please help. I seem to be having trouble with the time forma
functions
 
Hi Debbie,

Try

=MIN(TIME(8,0,0),B1-A1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top