Hello,
I'm new to Excel programming, but a very experienced Access-programmer.
I want to do some time calculation in Excel, but am already stuck with the if syntax.hat is the syntax for the following expression ?
If (timevalue in cell B6 > 17:45 then (17:45 minus timevalue in B2) else (timevalue in cell B3 minus timevalue in cell B2))
Any help will be greatly appreciated.
Thanks,
W
You get better help if you post an Excel-example of your workbook, without confidential information.
Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.
Use BEFORE/AFTER sheets if that helps make it clearer.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Try using =IF(B6>A1,A1-B2,B3-B2) I put the 17:45 in cell A1 so it can be used as a varible.
Dank voor uw antwoord. Om niet te veel elektronische post te genereren zal ik eerst de tip van BarryTSL volgen.
W
Thanks for your fast reply. I'll give it a try and I'll come back to you with the result.Originally Posted by BarryTSL
W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks