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

Calculate the median value before a specified list 0
Timetable 7
Subtract 12 hours from date/time 6
arrived in appt time 1
Creating Time Schedule in Excel 1
Data to Date conversion with multiple formats 1
Subtract times? 2
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 3

Top