If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
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...
Use:
=IF(C1>B1,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
"rvnwdr" <rvnwdr.1py5aa_1117627503.1146@excelforum-nospam.com> wrote in
message news:rvnwdr.1py5aa_1117627503.1146@excelforum-nospam.com...
>
> 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
>
need help with - time values...
Linear Mode
