time-sheet record with over 24 hours

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kkwaters - 16 Dec 2004 00:27 GMT

I want ot create a time sheet for my employees where I can have the first
column be the start time, and the second be the end time, with the ability to
start at 10pm and finish the shift at 8am, which is over the 24 hour mark.
Then have the hours totalled in the third column, with a subtotal for each
week, and total for two weeks. My current dilema is where the hours go over
the 24hour mark in the same day and getting the total of hours worked for
that day.

Reply to this Message

tjtjjtjt - 16 Dec 2004 00:55 GMT

You might get some help from here:
http://www.cpearson.com/excel/overtime.htm

tj

> I want ot create a time sheet for my employees where I can have the first
> column be the start time, and the second be the end time, with the ability to
[quoted text clipped - 3 lines]
> the 24hour mark in the same day and getting the total of hours worked for
> that day.

Reply to this Message

Frank Kabel - 16 Dec 2004 06:24 GMT

Hi
use a formula such as
=B1-A1+(B1<A1)
or
=MOD(B1-A1,1)

for working with working hours that span midnight

To total just just SUM. e.g.
=SUM(C1:C10)
and format the resulting cell with the custom format
[hh]:mm

Signature

Regards
Frank Kabel
Frankfurt, Germany

>I want ot create a time sheet for my employees where I can have the first
> column be the start time, and the second be the end time, with the ability
[quoted text clipped - 5 lines]
> the 24hour mark in the same day and getting the total of hours worked for
> that day.

Reply to this Message