View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Laurr456 View Post
Hello, I'm 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'm 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
Hi,

Have a look at the attached. Is this what you mean?

I've added 7:24 to a cell and referenced this in the formulas. That way if you ever find yourself with a different trigger time (i.e. you start working longer or shorter shifts) you only have to change the time in that one cell rather than all the formulas.

Let me know if any of it needs explaining further.

S.
Attached Files
File Type: zip Laurr456 Example.zip (8.2 KB, 50 views)