LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Difference between date & time calculation

Is there a way to calculate the difference between two dates only counting
working days, but also including the difference in times? I am familiar with
the NetWorkDays formula, however, I need to find the difference between the
specific times. Ex. We are trying to calculate the time it takes in days,
hours, minutes, for someone to perform a task. But we want do not want to
count the weekend days. So if someone starts a task on Friday at 8 am &
finishes the following Mon at 3 pm, can you create a formula for that?

Thanks

 
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
Date time difference JMB Excel Discussion (Misc queries) 5 March 12th 08 10:47 PM
Time difference calculation question Bob Wall Excel Worksheet Functions 1 January 2nd 08 05:25 AM
Time difference calculation Sasha Excel Worksheet Functions 5 July 22nd 06 05:55 AM
Date and time difference Danieljesse Excel Worksheet Functions 1 January 23rd 06 12:47 PM
Calculating Difference Between Start Date & Time And End Date & Ti Samwar Excel Discussion (Misc queries) 2 December 19th 05 12:42 PM


All times are GMT +1. The time now is 12:36 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"