Thread: How do I calculate hours worked on 3rd shift?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How do I calculate hours worked on 3rd shift?
Direct subtraction should work if you tell Excel that the times are for
different dates:
In A1, A2:

9/11/05 11:00 PM
9/12/05 7:00 AM

In A3 put:
=A2-A1 and format as hh:mm and you will see:

8:00
--
Gary''s Student


"Steve" wrote:

How do you set up a calculation to compute hours when the shift goes from 11:
p.m. to 7: a.m. Normal calculations won't work in this case.
Reply With QuoteReply With Quote