Re: Calculating hours

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 04/05/04 

Date: Tue, 6 Apr 2004 00:15:08 +0100

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)
"Debbie Dies >" <<Debbie.Dies.149ira@excelforum-nospam.com> wrote in message
news:Debbie.Dies.149ira@excelforum-nospam.com...
> I have been trying to subtract out regular hours from overtime hours. I
> 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 8
> hrs or under I want it to = c1.
>
> So long has I am not using time format I can get this to work.  But as
> soon has I use time format it won't work.
>
> Please help.  I seem to be having trouble with the time format
> functions.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
Quantcast