TImeIn-TimeOut-TimeIn-TimeOut-HoursWorked

C

ChefBoiRD

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|
+-------------------------------------------------------------------+
 
B

Bob Phillips

Shorter and simpler at the very least <vbg>

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Problem 1
State Tax Business Calculations Help 1
Possible to determine whether any one instance within many satisfy a criteria? 3
Complex Timesheet 10
Time Calculation thought process 8
Multiple If statements, Calculating quarterly % holding costs 0
Macro: Exporting Data to a LEGIBLE Excel Spreadsheet 1
Formula to sum based on a change in another column 2

Top