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...o&userid=23903
View this thread: http://www.excelforum.com/showthread...hreadid=375589

Use:
=IF(C1B1,C1-B1,1-(B1-C1))
and use the time format h:mm to display

For totalling, use:
=SUM(D1:D10)
assuming 10 rows of data, and format as dd:hh:mm because more than 24
hours will display the residual part in the format hh:mm. Example 27:00
will display 03:00. So changing to dd:hh:mm will display 1:03:00
correctly. If you want the display to show 27, then use:
=SUM(D1:D10)*24
and format as general

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375589

=MOD(C1-B1,1)

--
HTH

Bob Phillips

"rvnwdr" wrote in
message ...

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...o&userid=23903
View this thread: http://www.excelforum.com/showthread...hreadid=375589