software

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?--
LM813
------------------------------------------------------------------------
LM813's Profile: www.excelforum.com/member.php...oamp;userid=30385
View this thread: www.excelforum.com/showthread...hreadid=500492total hours =(C2-C1) (C4-C3) (C6-C5)
OF COURSE you may have to adjust the format for timeHi,

Try this...

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

Hope it helps!
--
ERR229quot;LM813quot; wrote:

gt;
gt; I am trying to set up a kind of unique time sheet - I want it to have 3
gt; in/out times, and a total number of HOURS worked per day. This is what
gt; I want it to look like:
gt;
gt; B C
gt; Time In: 8:00 AM
gt; Time Out: 12:00 PM
gt; Time In: 12:30 PM
gt; Time Out: 4:00 PM
gt; Time In: 5:30 PM
gt; Time Out: 7:00 PM
gt;
gt; Total hours: _____
gt;
gt; Could someone help me with a formula, please?
gt;
gt;
gt; --
gt; LM813
gt; ------------------------------------------------------------------------
gt; LM813's Profile: www.excelforum.com/member.php...oamp;userid=30385
gt; View this thread: www.excelforum.com/showthread...hreadid=500492
gt;
gt;

Of course make sure to use C not A in the cell references. Sorry!
--
ERR229quot;ERR229quot; wrote:

gt; Hi,
gt;
gt; Try this...
gt;
gt; =ABS(((A1-A2)*24) ((A3-A4)*24) ((A5-A6)*24))
gt;
gt; Hope it helps!
gt; --
gt; ERR229
gt;
gt;
gt; quot;LM813quot; wrote:
gt;
gt; gt;
gt; gt; I am trying to set up a kind of unique time sheet - I want it to have 3
gt; gt; in/out times, and a total number of HOURS worked per day. This is what
gt; gt; I want it to look like:
gt; gt;
gt; gt; B C
gt; gt; Time In: 8:00 AM
gt; gt; Time Out: 12:00 PM
gt; gt; Time In: 12:30 PM
gt; gt; Time Out: 4:00 PM
gt; gt; Time In: 5:30 PM
gt; gt; Time Out: 7:00 PM
gt; gt;
gt; gt; Total hours: _____
gt; gt;
gt; gt; Could someone help me with a formula, please?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; LM813
gt; gt; ------------------------------------------------------------------------
gt; gt; LM813's Profile: www.excelforum.com/member.php...oamp;userid=30385
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=500492
gt; gt;
gt; gt;


ERR229 Wrote:
gt; Hi,
gt;
gt; Try this...
gt;
gt; =ABS(((A1-A2)*24) ((A3-A4)*24) ((A5-A6)*24))
gt;
gt; Hope it helps!
gt; --
gt; ERR229
gt;

Yes, that does help! Thank you very much!! --
LM813
------------------------------------------------------------------------
LM813's Profile: www.excelforum.com/member.php...oamp;userid=30385
View this thread: www.excelforum.com/showthread...hreadid=500492