Thanks mate, you're a champ!
Yeah I've seen that one and it doesn't really do it for me ... the throw away line '... by subtracting the result of a calculation that uses the WEEKD...
Firstly, you'll need to get an understanding of Excel's Date arithmetic - this is a good source: Basic tracking could involve IF statements whe...
Hi Mynda I'm not sure what you mean by "select the merged column > Transform tab ...". I'm on Excel 2010 so I don't have a Transform tab, and my...
Thank you Sunny, I think this may have cracked it. My only concern is the non-uniqueness of the dates may produce erroneous results but that will t...
Thanks for that. We can't assume anything about the value of the ID and its relationship to Createdate, but I think your suggestion will work so lo...
I know what you mean - on an old box I used to run Office 2003 and Office 2007 and although it didn't seem to cause problems, Office was forever re-co...
Hi Ben Looking at your question and spreadsheet I assume that you want the time elapsed between E5 and D5 if F5 is blank, otherwise you want the ti...