| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate WORK-hours between end/start date
I need a formula to calculate WORK-hours(08:00-17:00) between end/start
date-time; -excluding WEEKENDS -excluding PUBLIC HOLIDAYS cellA2 09-06-2007 09:00:00 [START DATE-TIME] cellB2 11-06-2007 13:00:00 [END DATE-TIME] cellC2 [HOURS:MINUTES] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDF To Calculate Work hours between two dates Problem with code | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
