Aug 03 2021 09:05 AM
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.
Aug 03 2021 09:09 AM
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.
Aug 03 2021 09:26 AM
Aug 03 2021 09:27 AM
Aug 03 2021 09:28 AM
Aug 03 2021 09:32 AM
Aug 03 2021 09:43 AM
It very depend on how your data is formatted. To attach the file on Reply to post browse for file
Aug 03 2021 10:05 AM
Thank you. You may use formula as
=MOD(E7-C7,1)
if you have overnight shifts, or simply = E7-C7 if not. To that cell please apply custom number format (ctrl+1 staying on cell)
if you'd like to see result as 6:30.
If as 6.5 use formula
=MOD(E7-C7,1)*24
and apply format as
Please check attached.