Using this formula gives the error #NAME? when a difference of more than 1
day is found, why is this?

"Peo Sjoblom" wrote:

http://www.cpearson.com/excel/DateTimeWS.htm


--


Regards,


Peo Sjoblom


"DaveAsh" wrote in message
...
I am struggling to subtract a start date/time cell from a finish date/time
cell. I can do it using the =sum function, but this gives the total hour
difference. I need to change this to working hours (those hours between
9&5),
any ideas??

Thanks