Averaging time

[ctomblin]

Help! I need to average a series of times (shown in hours minutes) to show the average number of hours I work each month. So week 1 might be 42 h:21mins, week 2 might be 40h:56min and so on, but how can I calculate my average weekly work times.

 

[inarbeth]

On 2002-11-04 08:56, ctomblin wrote:
Help! I need to average a series of times (shown in hours minutes) to show the average number of hours I work each month. So week 1 might be 42 h:21mins, week 2 might be 40h:56min and so on, but how can I calculate my average weekly work times.

If your hours are shown as fractions: 42.35. 40.92 etc you could use the AVERAGE function.

 

[ctomblin]

I've tried that thanks, but convberting to fractions is a chore.

 

[IML]

On 2002-11-04 11:12, ctomblin wrote:
I've tried that thanks, but convberting to fractions is a chore.

What if you use
=AVERAGE(A1:A2)*24
as your formula and apply custom format of
# ?/60
This results in 41 38/60. Is this what you want?

 

[Mark W.]

What is the data type of your data (i.e., numeric datetime value or text)? What formatting is applied to the cells containing these values?

 

[ctomblin]

Hi. I input 40.25 for example and leave the format as General. Do you think I should input the data another way?

 

[Mark W.]

Why not input it as 40:25? Excel expects times to be entered using the time seperator specified in your Regional settings control panel. Usually, this is set to colon ).