Timesheets

Is there a way to create a timesheet that calculates working times? Say
work begins at 11 pm and ends at 7 am with 1 hr. for lunch. I would
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 does
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 am


---
Message posted from http://www.ExcelForum.com/

Hi
try
=(B1-A1+(B1A1)+D1-C1+(D1C1))*24

or just use
=B1-A1+(B1A1)+D1-C1+(D1C1)
and format the resulting cell as time

--
Regards
Frank Kabel
Frankfurt, Germany
"dah " schrieb im Newsbeitrag
...
Is there a way to create a timesheet that calculates working times?
Say
work begins at 11 pm and ends at 7 am with 1 hr. for lunch. I would
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 does
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 am


---
Message posted from http://www.ExcelForum.com/

See Chip Pearson's Timesheets pages.

http://www.cpearson.com/excel/overtime.htm

Gord Dibben Excel MVP

On Tue, 9 Mar 2004 16:22:40 -0600, dah
wrote:

Is there a way to create a timesheet that calculates working times? Say
work begins at 11 pm and ends at 7 am with 1 hr. for lunch. I would
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 does
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 am


---
Message posted from http://www.ExcelForum.com/

Thanks! The information was helpful and it worked.


---
Message posted from http://www.ExcelForum.com/