Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate hours of work substracting non-working time
We have an application that gives us these fields in Excel. These are logged jobs being performed for staff. Start Date (date the job started) StartTime Returned Date (date job was completed) Returned Time Turnaround hours (total hours including non-working time) If the job goes beyond the day it's started, I would like to create a calculation to determine the numbers of hours a job took minus 16 hours of non-working time for each day. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Time during different sets of work hours | Excel Worksheet Functions | |||
Calculate working hours from a start and finish time over several | Excel Worksheet Functions | |||
How do you subtract time as in a timecard to calculate hours work | Excel Worksheet Functions | |||
calculate hours on work sheet | Excel Worksheet Functions | |||
Calculate work hours between two dates | Excel Worksheet Functions |