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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate hours of work substracting non-working time
" wrote:
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. Try: =A5-16*(A3-A1) where A1 is the start date, A3 is the end date and A5 is the total hours. That assumes that A5 is indeed hours, not the format hh:mm. If the latter, then try: =A5-16*(A3-A1)/24 ----- original message ----- " wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate hours of work substracting non-working time
Thanks for your help
Rob "JoeU2004" wrote: " wrote: 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. Try: =A5-16*(A3-A1) where A1 is the start date, A3 is the end date and A5 is the total hours. That assumes that A5 is indeed hours, not the format hh:mm. If the latter, then try: =A5-16*(A3-A1)/24 ----- original message ----- " wrote in message ... 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 |
Reply |
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 |