Of course make sure to use C not A in the cell references. Sorry!
--
ERR229
"ERR229" wrote:
Hi,
Try this...
=ABS(((A1-A2)*24)+((A3-A4)*24)+((A5-A6)*24))
Hope it helps!
--
ERR229
"LM813" wrote:
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: http://www.excelforum.com/member.php...o&userid=30385
View this thread: http://www.excelforum.com/showthread...hreadid=500492