#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default time elapsed

I need a formula that will calculate the amount of time (in hours) that it
takes us to respond to a request, but i need hours of operations and not
include weekends. Our hours of operations are 8am to 5pm. I have a submit
date and time, and a respond date and time fields. Here are two examples:

Submit field 11/26/08 4:00 pm
Respond field 11/27/08 9:00 am
Response time should be = 2 hours.

Submit field: 11/26/08 6:00 pm
Response field: 11/27/08 9:00 am
Response time should be = 1 hour
Reply
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
Elapsed Time KevinT Excel Worksheet Functions 9 July 2nd 08 08:27 AM
Calculate Ending time using Start Time and Elapsed Time Chief 711 Excel Worksheet Functions 5 May 13th 08 04:34 PM
Elapsed time LtFass Excel Discussion (Misc queries) 3 November 10th 07 11:45 PM
Need Elapsed Time Help Jwy Excel Worksheet Functions 2 September 29th 05 03:54 AM
Elapsed time relux Excel Discussion (Misc queries) 1 February 16th 05 09:47 PM


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