Recent content by BobHunter

Excel 2007 Excel 2007 removes the ability to record me moving creating and moving rectangles. Does someone know the code/properties/objects required to create a Rectangle, and change its height, width, position and text ? I'm looking to create rectangles to give a visual representation of...

Forget it - I've sussed it. Novell Client is in the mix and this breaks AutoLogon on Vista : http://forums.novell.com/novell-product-support-forums/open-enterprise-server/oes-platform-independent/oes-client-windows/281257-novell-client-vista-breaks-sysprep-autologon.html Removing Novell fixes...

I have a base PC setup which successfully autologons. The below script changes the PC name and user accounts and should also make it auto logon. After the script is run, it does not autologon, but if I manually enter the password it does login proving the account and password have been renamed...

Nice one combo, that workaround has worked a treat - thanks.

Thanks Glenn. You've got it in one. I do have count of fix and sum of fix in a pivot table, and I am currently calculating the % manually using a formula. I was hoping some guru might know if this is possible in a pivot table with me having to manually redo the formulae for each refresh of the...

A pivot table is driving me insane at the moment. A very simplified example of the data is below Week CaseId Fix FW01 111111 1 FW01 111112 1 FW01 111113 1 FW02 111114 0 FW02 111115 1 FW03 111116 1 FW03 111117 1 FW03 111118 1 FW03 111119 0 What the pivot table should look...

Thanks very much - my small brain has finally cracked it... =IF(AND((A1-INT(A1))>0.2916666666,(A1-INT(A1))<0.791666666),"Days","Nights")

Okay 23/09/2005 8:43:57 PM in A1 If.... A1 > 7am AND < 7pm THEN "Dayshift" Else "NighShift" A1 > 7am is True A1 < 7pm is False ?

Good clue, but still not cracked it. 8am for example, evaluates true >7am (0.29167) but evaluates false <7pm (0.79167). Same result for 8pm. I am missing something ? A1 has 23/09/2005 8:43:57 PM in it, if that helps....

I need a formula to work out a shift pattern For example, I have a date/time in A1. If the time in A1 is between 7pm and 7am it is a nightshift If the time in A1 is between 7am and 7pm is is a dayshift Sounds simple but I've have not cracked it yet. Any help appreciated.

Date type.

Both of these resulted in an application error - the dreaded red X - dunno why. My date field in the db is formateed 21/01/04 12:10:00 if that helps. Would formulae be better, passed in as 2 parameters ? StartDate = CurrentDateTime etc ? Thanks for the help thus far... Bob.

Here's a teaser, not unlike my last post where I asked how to select the previous 12 hour period. I now need to select the current week for a report, where the StartDate will default to Saturday, 7am current week, and the EndDate will default to Saturday 7am next week. Eg. Today is 21st Jan...

Sorted it now and it works perfectly - thanks for all your help!

Lost me a bit, but it looks like exactly what I'm after.. I am using 2 parameter fields currently & my formula is : {HPD:HelpDesk.Resolved} >= {?StartDate} and {HPD:HelpDesk.Resolved} <= {?EndDate} Should I remove these 2 parameter fields and redeclare these in the formula or something ? Let...