Forum Discussion
EXCEL For Mac
What is the correct formula for determining the # of hours worked and not to have AM/PM show up in the answer column? Say they worked from 9:00 am to 4:30 pm = ?? Obviously it is 6.5 hours, bu...
I am so unfamiliar with this, but I do want it to show as "6.50" in the Total Time column then subtract whatever lunch time taken for the Total Hours column. Then to add the total hours column & then multiply by wage per hour (120) plus expenses for a Grand Total
July
Date Time In Time Out Total Time Lunch Total Hours
7/1/21 10:00 AM 2:00 PM 0
7/2/21 10:00 AM 12:00 PM 0
7/5/21 10:00 AM 12:00 PM 0
7/6/21 9:00 AM 1:00 PM 0
7/7/21 12:30 PM 6:30 PM 0
7/8/21 8:15 AM 5:00 PM 0
7/9/21 9:00 AM 1:00 PM 0
7/12/21 8:30 AM 4:30 PM 0
7/13/21 8:30 AM 4:45 PM 0
7/14/21 8:15 AM 3:30 PM 0
7/15/21 8:00 AM 6:00 PM 0
7/16/21 9:00 AM 5:30 PM 0
7/19/21 8:00 AM 4:45 PM 0
7/20/21 8:15 AM 4:30 PM 0
7/21/21 9:00 AM 3:15 PM 0
7/22/21 8:00 AM 4:45 PM 0
7/23/21 10:00 AM 2:00 PM 0
7/26/21 9:00 AM 3:00 PM 0
7/27/21 9:00 AM 4:15 PM 0
7/28/21 10:00 AM 3:00 PM 0
7/29/21 10:00 AM 5:30 PM 0
7/30/21 9:00 AM 12:00 PM 0
120
Total
Expenses
Grand Total To Be Paid
Date Time In Time Out Total Time Lunch Total Hours
7/1/21 10:00 AM 2:00 PM 0
7/2/21 10:00 AM 12:00 PM 0
7/5/21 10:00 AM 12:00 PM 0
7/6/21 9:00 AM 1:00 PM 0
7/7/21 12:30 PM 6:30 PM 0
7/8/21 8:15 AM 5:00 PM 0
7/9/21 9:00 AM 1:00 PM 0
7/12/21 8:30 AM 4:30 PM 0
7/13/21 8:30 AM 4:45 PM 0
7/14/21 8:15 AM 3:30 PM 0
7/15/21 8:00 AM 6:00 PM 0
7/16/21 9:00 AM 5:30 PM 0
7/19/21 8:00 AM 4:45 PM 0
7/20/21 8:15 AM 4:30 PM 0
7/21/21 9:00 AM 3:15 PM 0
7/22/21 8:00 AM 4:45 PM 0
7/23/21 10:00 AM 2:00 PM 0
7/26/21 9:00 AM 3:00 PM 0
7/27/21 9:00 AM 4:15 PM 0
7/28/21 10:00 AM 3:00 PM 0
7/29/21 10:00 AM 5:30 PM 0
7/30/21 9:00 AM 12:00 PM 0
120
Total
Expenses
Grand Total To Be Paid
July- I don't know how to attach the file so you can see it exactly
It very depend on how your data is formatted. To attach the file on Reply to post browse for file
