 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2005TImeIn-TimeOut-TimeIn-TimeOut-HoursWorked
Bob Phillips Wrote: > Shorter and simpler at the very least vbg > > =((J7-G7)-IF(AND(H7"",I7""),I7-H7,0))*24 > > -- > HTH > > Bob Phillips > > snip I tried it but excel would only accept it without the quotations after (H7"",I7""). Then, I would get "#NAME?" error...may need the HOUR MINUTE in there somewhere??? Will experiment some more... Thanks!  SignatureChefBoiRD Something happened in the posting, what is in your message is not what I posted. I used =((J7-G7)-IF(AND(H7<>"",I7<>""),I7-H7,0))*24 note the <> between H7 and "" and I7 and "" Please re-try with this formula. SignatureHTH Bob Phillips > Bob Phillips Wrote: > > Shorter and simpler at the very least vbg [quoted text clipped - 11 lines] > (H7"",I7""). Then, I would get "#NAME?" error...may need the HOUR > MINUTE in there somewhere??? Will experiment some more... Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.