If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Time Calculation and formulas needed (2 questions)
#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, "" |
#2
|
|||
|
|||
Time Calculation and formulas needed (2 questions)
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, "" |
Thread Tools | |
Display Modes | |
|
|