Windows 7 - Trying to work out a formula for time lost/gained

Asked By Laurr456 on 13-Aug-12 10:37 AM
Hello, I am not a complete novice when it comes to excel but I dont have
much experience with anything other than simple formulas...

This is a bit tricky to explain but i'll try my best...

I am trying to devise a table to highlight time lost or gained in a
single day.

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


Any help is appreciated as all i've managed to do it get it to show the
time worked or 0 in the 2nd and 3rd colums.

TIA


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Laurr456




Claus Busch replied to Laurr456 on 13-Aug-12 03:56 PM
Hi,

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


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
Claus Busch replied to Claus Busch on 13-Aug-12 04:00 PM
Hi,

Am Mon, 13 Aug 2012 21:56:11 +0200 schrieb Claus Busch:


sorry, I copied one formuala twice
in B2:
=IF(A2>TIME(7,24,),A2-TIME(7,24,),"")
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
Laurr456 replied to Claus Busch on 14-Aug-12 05:26 AM
Wow, thank you both so much - problem solved!! :)


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Laurr456