| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calcuate mean and median of time (d hh:mm) data?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to calcuate mean and median of time (d hh:mm) data?
=AVERAGE()
=MEDIAN() -- David Biddulph "kp" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to calcuate mean and median of time (d hh:mm) data?
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. "kp" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating median of time period | Excel Discussion (Misc queries) | |||
| How to calcuate the difference between two times in tenths of a mi | Excel Discussion (Misc queries) | |||
| calcuate bond yields | Excel Worksheet Functions | |||
| How do I calcuate an IC50 from analyze it? | Excel Worksheet Functions | |||
| calcuate sales by date and segments | Excel Worksheet Functions | |||
Linear Mode
