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, but when I put the formula I think is right, it adds an am/pm in the answer when all I want is the # of hours.
8 Replies
If you want the result in the format 6:30, apply the custom format h:mm to the cells with the hours worked formula.
If you want the result in the format 6.5, multiply the time difference with 24 and format the cells with the formula as General or as Number with one or two decimal places.
- 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
