LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default difference of date/time only calculating workingdays/hours

Can you please help me. I need to calculate the difference between two dates
which also contain the timestamp but I would like it to only count the normal
working time - 8 hours per day and not weekends
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time difference from 24 hours The Incredible Excel Discussion (Misc queries) 3 October 17th 08 01:20 PM
Calculating the difference between hours Oliver Excel Worksheet Functions 1 June 1st 08 07:48 PM
Difference of time in hours or minutes Charles Excel Discussion (Misc queries) 2 September 13th 06 11:12 PM
Calculating Difference Between Start Date & Time And End Date & Ti Samwar Excel Discussion (Misc queries) 2 December 19th 05 12:42 PM
calculate difference in time to hours Chris Excel Worksheet Functions 5 January 18th 05 06:07 PM


All times are GMT +1. The time now is 05:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"