TImeIn-TimeOut-TimeIn-TimeOut-HoursWorked

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChefBoiRD - 18 Sep 2005 04:12 GMT

This worked for me for a 5 column Time Sheet (Line 7)... providing that
the center time out/in is used for lunch or left blank if no lunch is
taken....is there a better array out there?

=IF(H7=I7,((((HOUR(J7)*60)+(MINUTE(J7)))-((HOUR(G7)*60)+(MINUTE(G7)))))/60,((((HOUR(J7)*60)+(MINUTE(J7)))+((HOUR(H7)*60)+(MINUTE(H7)))-((HOUR(I7)*60)+(MINUTE(I7)))-((HOUR(G7)*60)+(MINUTE(G7))))/60))

I used other functions to set dates/times and hour totals. See the
attachment for the layout.

+-------------------------------------------------------------------+

|Filename: Timesheet.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=32|

+-------------------------------------------------------------------+

Signature

ChefBoiRD

Reply to this Message

Bob Phillips - 18 Sep 2005 10:30 GMT

Shorter and simpler at the very least <vbg>

=((J7-G7)-IF(AND(H7<>"",I7<>""),I7-H7,0))*24

Signature

HTH

Bob Phillips

> This worked for me for a 5 column Time Sheet (Line 7)... providing that
> the center time out/in is used for lunch or left blank if no lunch is
> taken....is there a better array out there?

=IF(H7=I7,((((HOUR(J7)*60)+(MINUTE(J7)))-((HOUR(G7)*60)+(MINUTE(G7)))))/60,(
(((HOUR(J7)*60)+(MINUTE(J7)))+((HOUR(H7)*60)+(MINUTE(H7)))-((HOUR(I7)*60)+(M
INUTE(I7)))-((HOUR(G7)*60)+(MINUTE(G7))))/60))

> I used other functions to set dates/times and hour totals. See the
> attachment for the layout.
[quoted text clipped - 3 lines]
> |Download: http://www.excelbanter.com/attachment.php?attachmentid=32|
> +-------------------------------------------------------------------+

Reply to this Message