How to calcuate mean and median of time (d hh:mm) data?

K

kp

I have time data in an excel column (formatted as d hh:mm and also as hh:mm
(2 seperate sets) . I need to find out the mean (average) and the median for
these sets. How should I go about it?
 
F

Fred Smith

Times are just numbers to Excel. You calculate the Average and Median the
same way you do with any other set of numbers.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates in Excel 2003 1
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
Date & Time Format 7
Median Question 4
More Median Questions 2
Time Formula 4
Disabling the "&[Time]" or "&[T]" in Excel headers and footers 2
How to stop excel 2007 automatically changing my date format? 2

Top