Timesheets

  • Thread starter Thread starter dah
  • Start date Start date
D

dah

Is there a way to create a timesheet that calculates working times? Sa
work begins at 11 pm and ends at 7 am with 1 hr. for lunch. I woul
like Excel to calculate the number of hours worked.

I got this to work beginning at 7 am and ending at 4 pm, but it doe
not work the opposite.

Example:
A1 B1 C1 D1
7 am 11:00 12:00 4:00 Returns 8 hr.

=((B1-A1)+(D1-C1))*24

How can I get the numbers below to figure the hours worked?

A1 B1 C1 D1
11 pm 3 am 4 am 7 a
 
Hi
try
=(B1-A1+(B1<A1)+D1-C1+(D1<C1))*24

or just use
=B1-A1+(B1<A1)+D1-C1+(D1<C1)
and format the resulting cell as time
 
Back
Top