Hi,

Am Thu, 25 Oct 2012 11:29:24 -0700 (PDT) schrieb :

Hello it works fine to calcualte total work time. But I need split the total work time work on 10/22 and Total work time on 10/23
So on 10/22 the total hours would be 1hour and 30 minutes and 10/23 would be 9hours So I would need to diffrent forlulas I'm asumming.

for 10/22:
=1-MOD(B2,1)
for 10/23:
=MOD(C2,1)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2