Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Work Hours
I've seen some posts using Workdays function to find elapsed time from
date/time A1 to date/time B1; I'm trying to utilize this, but I have some data that actually begins after prescribed business hours and/or ends before... the formula I'm using doesn't like those scenarios... is there something that I can do to allow it to continue calculating JUST business hours, despite start/stop time anomolies? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Work Hours
Brent,
Visit Chip Pearson's excellent website: http://www.cpearson.com/excel/DateTimeWS.htm HTH, Bernie MS Excel MVP "Brent" wrote in message ... I've seen some posts using Workdays function to find elapsed time from date/time A1 to date/time B1; I'm trying to utilize this, but I have some data that actually begins after prescribed business hours and/or ends before... the formula I'm using doesn't like those scenarios... is there something that I can do to allow it to continue calculating JUST business hours, despite start/stop time anomolies? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting work hours to day/hours/minutes | Excel Discussion (Misc queries) | |||
Calculating hours between 35 and 40 | Excel Worksheet Functions | |||
Determining work hours between dates / hours | Excel Worksheet Functions | |||
calculating hours work has taken | Excel Discussion (Misc queries) | |||
Calculating total work week hours | Excel Worksheet Functions |