LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Sandy
 
Posts: n/a
Default NEED HELP - Calculating dates and times

Hello,

Below is an example of my spreadsheet...

RecvdDate RecvdTime ClosedDateClosedTimeCall Duration
9/3/2004 10:39:22 9/3/2004 12:35:37 (Need formula)
5/9/2005 16:00:52 5/12/2005 14:34:47
5/12/2005 11:57:11 5/12/2005 12:48:35
5/12/2005 12:55:53 5/12/2005 14:51:19
5/13/2005 13:39:08 5/16/2005 15:21:58
5/17/2005 16:58:59 5/25/2005 13:00:01

I need to determine the hours it takes to resolve a Help Desk issue. I hope
that you can help me with this.

Sandy
 
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
How do I calculate duration between two dates and times in excel? Robin CSM002 Excel Discussion (Misc queries) 3 May 13th 23 07:42 PM
Dates and times again Martin B Excel Worksheet Functions 13 April 26th 05 10:25 PM
merge dates and times into one column? Jack Excel Discussion (Misc queries) 2 April 13th 05 05:38 PM
Formula to calculate elapsed time between certain dates and times Stadinx Excel Discussion (Misc queries) 6 March 25th 05 07:02 AM
Times and Dates rob1972 Excel Discussion (Misc queries) 0 March 7th 05 04:40 AM


All times are GMT +1. The time now is 12:06 AM.

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"