Averaging time

ctomblin

New Member
Joined
Apr 25, 2002
Messages
49
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.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

inarbeth

Well-known Member
Joined
Apr 8, 2002
Messages
912
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.
 

IML

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,743
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.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654

ADVERTISEMENT

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

New Member
Joined
Apr 25, 2002
Messages
49
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.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
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 :)).
 

Forum statistics

Threads
1,144,743
Messages
5,726,025
Members
422,654
Latest member
Yashpalknl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top