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