Hi,

Am Mon, 13 Aug 2012 14:37:14 +0000 schrieb Laurr456:

1. In the first column I want the amount of time worked (in hours and
minutes)
2. In the second, if the time worked exceeds 7hrs 24mins then I would
like the aditional time to show (e.g if worked 8hrs 34mins I would like
1hr 10mins to show, preferably as 1:10)
3. In the third, if the time worked is less than 7hrs 24mins. I would
like the time lost to show

in B2:
=IF(A2<TIME(7,24,),TIME(7,24,)-A2,"")
in C2:
=IF(A2<TIME(7,24,),TIME(7,24,)-A2,"")



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