Hi,

I use the following formula all the time: =IF(H2="Saturday",
"Saturday", IF(H2="Sunday", "Sunday", IF(K20.79, "Evening",
"Daytime"))), where the H column has the day of the week and the K
column the time.

Each time I have a new speadsheet I type this in from scratch and copy
it down for as many rows as I have (generally a few thosand), not a big
deal I'll grant you.

I was wondering would it be 'better' to make a custom function that
performs this task and if so how should one go about this. I
understand the concepts around creating a custom function but it's all
very new.

Any help would be appreicated.

Andy.


--
andyiain
------------------------------------------------------------------------
andyiain's Profile: http://www.excelforum.com/member.php...fo&userid=8335
View this thread: http://www.excelforum.com/showthread...hreadid=528528