View Single Post
  #2   Report Post  
lozzauk13 lozzauk13 is offline
Junior Member
 
Posts: 4
Default

Quote:
Originally Posted by Claus Busch View Post
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.