Hi!!
I have tried to change the format on both the cells where I have merged
the date and time And the cells where I woul like the result for the
duration to take place but without luck. I now only get #VALUE.
The merge formula now looks like this:
=CONCATENATE(TEXT(I2;"ลลลล-MM-DD");" ";TEXT(J2;"t:mm:ss"))
The duration formula looks like this:
=NETWORKDAYS(TEXT(J2-L2;"ลลลล-MM-DD t:mm:ss"))
I have also formated the cells where the result is displayed to
[t]:mm:ss but still the same error.
--
ajajmannen
------------------------------------------------------------------------
ajajmannen's Profile:
http://www.excelforum.com/member.php...o&userid=34130
View this thread:
http://www.excelforum.com/showthread...hreadid=542987