Re: [OT] Excel Golf: Unix Time to Excel Time in one line

On Tue, 26 Oct 2004, McGlinchy, Alistair wrote:
>
> Here's a horrid 297 Byte solution:
>
> =	DATE(1970,1,1)+ A2/24/60/60+1/24 *
> 	AND(
> 		DATE(YEAR(DATE(1970,1,1)+A2/24/60/60),5,1)
> 			-
> 		WEEKDAY(DATE(YEAR(DATE(1970,1,1)+A2/24/60/60),5,1),2)
> 			+
> 		1/24
> 	<
> 		DATE(1970,1,1)+A2/24/60/60
> 	,
> 		DATE(1970,1,1)+A2/24/60/60
> 	<
> 		DATE(YEAR(DATE(1970,1,1)+A2/24/60/60),11,1)
> 			-
> 		WEEKDAY(DATE(YEAR(DATE(1970,1,1)+A2/24/60/60),11,1),2)
> 			+
> 		1/24
> 	)
>
>

I don't know much about Excel, but I think DATE(1970,1,1) can be spelled
25569. If I'm right, that would save you at least 63 strokes.

-- 
Stephen Turner, Cambridge, UK    http://homepage.ntlworld.com/adelie/stephen/
  "Low Priced Cambridge Clare College. Big selection at eBay UK!"
  (Ad after Google search for Clare College Cambridge)