Hi,

Am Sat, 27 Apr 2013 13:34:12 +0100 schrieb lozzauk13:

right ive solved some of that issue, the only issues i have at the
moment now is different amounts on the same calculation and also it
showing 30 mins break on blank boxes(i need the blanks incase a date
gets added)

then try:
=IF(OR(B1="",A1=""),"",B1-A1-IF(B1-A1=0.5,1/24,1/48))


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

thanks claus that took away the ###### and ive hidden the break box just so it states the total hours minus the break, its just the difference in 31 x 7.18 and 31 x 7:18 now thats causing the issue.

Hi,

Am Sat, 27 Apr 2013 16:15:16 +0100 schrieb lozzauk13:

thanks claus that took away the ###### and ive hidden the break box just
so it states the total hours minus the break, its just the difference in
31 x 7.18 and 31 x 7:18 now thats causing the issue.

you can't set 7.18 = 7:18
7:18 is 7 hours and 18 minutes
7,18 is 7 hours and 10 minutes

That will make a difference of 4,13 hours or
4:08


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