need help with - time values...


Can anyone help me with this problem?

I am making a table that will calculate hrs worked. Column B has the
hr started. Column C has the end time. Note - the start time can be
in the evening and the end time can be in the am of the next day -
giving me a negetive number.

I would need the easiest way to find the time difference between the
two. This would be my column D. I would then need to add these two
columns up to figure the total number hrs worked...

Thanks! :)


--
rvnwdr
------------------------------------------------------------------------
rvnwdr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23903
View this thread: http://www.excelforum.com/showthread.php?threadid=375589

.

Relevant Pages

  • problem adding
    ... My spread sheet ... rvnwdr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23903 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • help with if formulas
    ... of 8 if the value of column c is greater then 5 hrs but show me a value ... rvnwdr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23903 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: help with sumif to calculate column
    ... Am I missing something? ... rvnwdr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23903 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Dates in IF statements
    ... gives the time difference in years between a date in A1 and a date in ... daddylonglegs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30486 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • RE: Formula counts incorrectly
    ... > I assume that it is only counting 5/5/2005 one time? ... > Could someone please modify this formula to work the way I want it to? ... > was's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20211 ... Prev by Date: ...
    (microsoft.public.excel.misc)