Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Deducting breaks from time measurements
Hi,
First part pretty simple. Column A = Start Time, Column B = End Time. As times always occur in the same day then to find the time spent is a simple "B-A". However for the next part... I wish to be able to deduct break times from the time spent. If we have three breaks a day between say 10:00 - 10:30 12:30 - 13:30 14:30 - 15:00 then if any of these intervals occur between the start time and end time then i would like to deduct the period of the break (i.e. 30 mins or 1 hour). I could probably achieve this using lots of nested IFs and lookups but I was wondering if there was an easier way? Any and all advice is gratefully received. regards Chris. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
Formula to deduct unpaid breaks in time sheet | Excel Discussion (Misc queries) | |||
Time Sheets | New Users to Excel | |||
unmet challenge | Excel Worksheet Functions |