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, "" |
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, "" |
All times are GMT +1. The time now is 08:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com