Time Sheets (Yes, I've already done a search on previous posts)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LM813 - 12 Jan 2006 03:43 GMT

I am trying to set up a kind of unique time sheet - I want it to have 3
in/out times, and a total number of HOURS worked per day. This is what
I want it to look like:

B C
Time In: 8:00 AM
Time Out: 12:00 PM
Time In: 12:30 PM
Time Out: 4:00 PM
Time In: 5:30 PM
Time Out: 7:00 PM

Total hours: _____

Could someone help me with a formula, please?:confused:

Signature

LM813

Reply to this Message

damorrison - 12 Jan 2006 04:07 GMT

total hours =(C2-C1)+(C4-C3)+(C6-C5)
OF COURSE you may have to adjust the format for time

Reply to this Message

ERR229 - 12 Jan 2006 16:40 GMT

Hi,

Try this...

=ABS(((A1-A2)*24)+((A3-A4)*24)+((A5-A6)*24))

Hope it helps!

Signature

ERR229

> I am trying to set up a kind of unique time sheet - I want it to have 3
> in/out times, and a total number of HOURS worked per day. This is what
[quoted text clipped - 11 lines]
>
> Could someone help me with a formula, please?:confused:

Reply to this Message

ERR229 - 12 Jan 2006 16:43 GMT

Of course make sure to use C not A in the cell references. Sorry!

Signature

ERR229

> Hi,
>
[quoted text clipped - 19 lines]
> >
> > Could someone help me with a formula, please?:confused:

Reply to this Message

LM813 - 13 Jan 2006 00:04 GMT

ERR229 Wrote:

> Hi,
>
[quoted text clipped - 5 lines]
> --
> ERR229

Yes, that does help! Thank you very much!! :)

Signature

LM813

Reply to this Message