LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Adding Times

[Tom Olgilvy = I really appreciate your help. The answer you gave to my last
question about date/time calculation really helped me out from both a
learning perspective and from a solutions perspective. Many Thanks.]

To extend my problem - I have 2 columns that have date and time stamps in
them. How do I find the Maximum Time, Minimum Time, and the Average Time
given a time format of 2:11:00 PM.

Background - the report counts the number of trouble tickets by priority,
provides a count by Age of the tickets over a range, and it provides the min,
max, and avg handle times.

I dont know how to Sum the Times and find the average? Can anyone help?


Thanks again.

 
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
Adding times Jaime Excel Worksheet Functions 1 August 11th 06 05:27 PM
Adding times mel_flynn Excel Programming 1 November 30th 05 02:44 PM
Adding up Times Lisa Excel Worksheet Functions 2 September 1st 05 02:32 PM
ADDING TIMES John C. Harris, MPA Excel Worksheet Functions 5 August 9th 05 05:32 PM
Adding Times B. Jensen Excel Programming 4 April 1st 05 11:50 PM


All times are GMT +1. The time now is 02:42 PM.

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

About Us

"It's about Microsoft Excel"