#1
I'm creating a time sheet and set it up for time in and out to have separate
cells using the h:mm AM/PM format. In a separate cell I have amount of time
taken ro lunch. The cell for entering the calculation is set up to convert
to decimal format rather than time.

I do not know how to complete the following formula so that it recognizes 5
hours:

=IF(F10-E105 hours, F10-E10-A10, F10-E10)*24

Goal: I want to subtract lunch time if I work over 5 hours, otherwise Iwant
to know the hours worked if under 5 hours)

#2 I think I need an array formula (within one cell):
If cell I100, V, ""
If cell J100, S, ""
If cell K100, P, ""

Ans #1:
=(((F10-E10)--"5:00")*-A10-E10+F10)*24

format as General

Ans #2:
=IF(I100,"V",IF(J100,"S",IF(K100,"P","")))


"--Viewpoint" wrote:

#1
I'm creating a time sheet and set it up for time in and out to have separate
cells using the h:mm AM/PM format. In a separate cell I have amount of time
taken ro lunch. The cell for entering the calculation is set up to convert
to decimal format rather than time.

I do not know how to complete the following formula so that it recognizes 5
hours:

=IF(F10-E105 hours, F10-E10-A10, F10-E10)*24

Goal: I want to subtract lunch time if I work over 5 hours, otherwise Iwant
to know the hours worked if under 5 hours)

#2 I think I need an array formula (within one cell):
If cell I100, V, ""
If cell J100, S, ""
If cell K100, P, ""