Time Sheets

[Lady Layla]

I have looked at various Time calculation examples but have not seen this really
addressed

Is there a way to have a time sheet where people do not need to enter time using
military time or using AM or PM in the actual entry.

We have a business that is a normal 9 - 5 business so there is no overnight or
really late night work hours.

If start time is in C2 , lunch out in D2, lunch in in E2, time out in F2.

Normal time calculation is (F2-E2+D2-C2)*24


Am trying to use (IF(F2>E2,F2-E2,(E2+12)-E2)+If(D2>C2,D2-C2,(D2+12)-C2))*24
but am not getting correct answer


(Trying to add 12 hours to Lunch out or Time out if beginning times are in AM
and ending times are in PM)

Thanks in advance for the help!

 

[Niek Otten]

=(IF(F2>E2,F2-E2,(F2+12)-E2)+IF(D2>C2,D2-C2,(D2+12)-C2))

If you don't want military time, don't multiply by 24. Further, a little
typo; F2 vs. E2
If you want to use the result as real Excel time, divide by 24.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel