Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
![]()
I wrote this function, the logics seem to ok, but there are too many logic,
as I the result I think I mess up the syntax. Can anyone correct for me? the function is: =IF(AND(F8<"X",F8=""),C3-D8,IF(F8<"",C3-F8)IF(AND(G8<"X",G8=""),C3-F8)*IF(G8<0,C3-G8)*IF(AND(H8<"X",H8=""),C3-G8,)IF(H8<"",C3-H8,0)) where C3 is a now() function with customed to time, and where D8 is the beginning time for an employee. The function above time elapsed from the 1 break to 3 break. Each time a break is entered now() function or C3 has to minus the time starting a break, then this equal to time elapsed since last break..thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
syntax correction | New Users to Excel | |||
Auto Correction | Excel Discussion (Misc queries) | |||
correction | Excel Discussion (Misc queries) | |||
Error correction | Excel Discussion (Misc queries) | |||
correction of formula please............ | Excel Worksheet Functions |