Hi Fred, thanks for the reply and the help. I've never used this kind of site
before and its amazing how helpful and polite people sre.
Unfortunately some of our orders are on the system for more than 24 hours,
due to the complexity of stock. Is there any way to do this for times
greater than 24 hours?
Best Regards,
Kevo

"Fred Smith" wrote:

Try this:
A1 = start time
A2 = end time

=a2-a1+(a2<a1)*time(14,0,0)

This will work as long as you finish the job within a 24-hour period.

Regards,
Fred.

"Kevo" wrote in message
...
Hi David, thank you for your prompt reply.
Very helpful.
My new problem is how to "remove" the hours we don't work from 8pm at
night
to 6am the next morning (10 hours we are not open).
Any suggestions?
Thanks,
Kevo

"David Biddulph" wrote:

To deal with wrapping round at midnight, use =MOD(B2-A,1) and format as
time.
If you are taking more than 24 hours, then you'd have to input date and
time.
--
David Biddulph

"Kevo" wrote in message
...
I am using Excel 2007 and trying to calculate the actual time it takes
to
pick orders.
Work day starts at 06:00 and ends at 20:00. using simple [end time] -
[start time] calulation. How do i calculate the hours if the job goes
in
to
the next day? I am a novice, as you can tell, but desperate to learn.
Kevo