LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
external usenet poster
 
Posts: 29
Default syntax correction

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
syntax correction Richard New Users to Excel 4 February 14th 07 08:30 PM
Auto Correction david.salazar Excel Discussion (Misc queries) 1 July 19th 06 05:24 PM
correction nowfal Excel Discussion (Misc queries) 4 March 24th 06 06:40 PM
Error correction Lisleb Excel Discussion (Misc queries) 5 August 30th 05 04:48 PM
correction of formula please............ azmi Excel Worksheet Functions 1 June 11th 05 08:41 PM


All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"