Yeah, that'll work if you don't want any robustness built in.

Biff

"daddylonglegs"
wrote in message
news:daddylonglegs.26siga_1145918103.7933@excelfor um-nospam.com...

Assuming a nine hour day - no lunch break - and your start time and end
time both to be within work hours

=(NETWORKDAYS(A1,B1)-1)*9+(MOD(B1,1)-MOD(A1,1))*24

format as number


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=535417