| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtracting Night-time-hours
I have a workbook that captures the hours that someone has spent reviewing
documentation (i.e. The time they received it and the time they returned it), and then it totals the hours. The problem I am having is that if they happen to not return the document until a few days later than I get an exorbitant result when in actuality there is only 9 working hours a day and only five days a week. Here's what I'm looking at... Col C Col D Col E Row 439 08-29-06 9:10 AM 09-01-06 8:01 AM 70 hours 51 minutes ' Derrived from this code -- =IF(D439<FALSE,D439-C439,"") I need it to be this... Col C Col D Col E Row 439 08-29-06 9:10 AM 09-01-06 8:01 AM 25 hours 51 minutes ' by subtracting 15 hours for each night Does anyone know how I can mathimatically accomplish this by modifying this code so that it accounts for the evenings and weekends? -- =IF(D439<FALSE,D439-C439,"") Thank You Sooo Much. Rob |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subtracting Night-time-hours
http://www.cpearson.com/excel/DateTimeWS.htm
Working Days And Hours Between Two Dates And Times -- Regards, Tom Ogilvy "Rob" wrote in message ... I have a workbook that captures the hours that someone has spent reviewing documentation (i.e. The time they received it and the time they returned it), and then it totals the hours. The problem I am having is that if they happen to not return the document until a few days later than I get an exorbitant result when in actuality there is only 9 working hours a day and only five days a week. Here's what I'm looking at... Col C Col D Col E Row 439 08-29-06 9:10 AM 09-01-06 8:01 AM 70 hours 51 minutes ' Derrived from this code -- =IF(D439<FALSE,D439-C439,"") I need it to be this... Col C Col D Col E Row 439 08-29-06 9:10 AM 09-01-06 8:01 AM 25 hours 51 minutes ' by subtracting 15 hours for each night Does anyone know how I can mathimatically accomplish this by modifying this code so that it accounts for the evenings and weekends? -- =IF(D439<FALSE,D439-C439,"") Thank You Sooo Much. Rob |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subtracting Night-time-hours
Holy Cow... Is there an easier way that's not so confusing?
"Tom Ogilvy" wrote: http://www.cpearson.com/excel/DateTimeWS.htm Working Days And Hours Between Two Dates And Times -- Regards, Tom Ogilvy "Rob" wrote in message ... I have a workbook that captures the hours that someone has spent reviewing documentation (i.e. The time they received it and the time they returned it), and then it totals the hours. The problem I am having is that if they happen to not return the document until a few days later than I get an exorbitant result when in actuality there is only 9 working hours a day and only five days a week. Here's what I'm looking at... Col C Col D Col E Row 439 08-29-06 9:10 AM 09-01-06 8:01 AM 70 hours 51 minutes ' Derrived from this code -- =IF(D439<FALSE,D439-C439,"") I need it to be this... Col C Col D Col E Row 439 08-29-06 9:10 AM 09-01-06 8:01 AM 25 hours 51 minutes ' by subtracting 15 hours for each night Does anyone know how I can mathimatically accomplish this by modifying this code so that it accounts for the evenings and weekends? -- =IF(D439<FALSE,D439-C439,"") Thank You Sooo Much. Rob |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Subtracting Night-time-hours
OK That gave no help. I did the whole names thing but It doesn't compute the
specific days that I need it to compute and I can't figure out how to make the codes on that page work with what I need to do. Feeling Bummed, Rob "Rob" wrote: Holy Cow... Is there an easier way that's not so confusing? "Tom Ogilvy" wrote: http://www.cpearson.com/excel/DateTimeWS.htm Working Days And Hours Between Two Dates And Times -- Regards, Tom Ogilvy "Rob" wrote in message ... I have a workbook that captures the hours that someone has spent reviewing documentation (i.e. The time they received it and the time they returned it), and then it totals the hours. The problem I am having is that if they happen to not return the document until a few days later than I get an exorbitant result when in actuality there is only 9 working hours a day and only five days a week. Here's what I'm looking at... Col C Col D Col E Row 439 08-29-06 9:10 AM 09-01-06 8:01 AM 70 hours 51 minutes ' Derrived from this code -- =IF(D439<FALSE,D439-C439,"") I need it to be this... Col C Col D Col E Row 439 08-29-06 9:10 AM 09-01-06 8:01 AM 25 hours 51 minutes ' by subtracting 15 hours for each night Does anyone know how I can mathimatically accomplish this by modifying this code so that it accounts for the evenings and weekends? -- =IF(D439<FALSE,D439-C439,"") Thank You Sooo Much. Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting 2 hours from a time.... | Excel Worksheet Functions | |||
| Subtracting more than 24 hours from a Date/Time | Excel Worksheet Functions | |||
| adding/subtracting # of hours from a time | Excel Discussion (Misc queries) | |||
| Subtracting hours from time | Excel Discussion (Misc queries) | |||
| Subtracting 2 hours from time | Excel Discussion (Misc queries) | |||
Linear Mode
