Times are actually a fraction of a day. When entering times if you enter the
date with the time then you are more likely to get the results you expect.

Midnight can be entered 2 ways. If you enter Jan 1 2010 24:00 then it will
actually convert to Jan 2 00:00. The reason for this is that 24:00 hours is a
full day (or 1) and therefore it rolls over to the next day. However, if you
want to enter Jan 1 00:00 then it will remain as Jan 1 00:00 so you need to
think about what time you actually want.

When formatting times, use the square brackets around the hours to prevent
summed times converting to days and time and therfore displaying incorrectly.

Example format as [hh]:mm

Example if you sum 12:00 and 15:00 it should be 27:00 but if not formatted
with the square brackets it will display as 03:00. Looking at the formula bar
it will look like 1/01/1900 3:00:00 AM because it has added one day to the
time and shows the remaining 3 hrs.

Note that you can enter the times with the dates and still format as hours
and minutes so that the dates are not actually displayed on the screen but
they are still there for the purposes of calculation.

Try the above and see if it fixes your problem.


--
Regards,

OssieMac


"Exec. Lt. GMP" wrote:

SIGN IN RELEASE TOTAL TIME
20:20 1:37 5:17
20:20 1:43 5:23
21:07 3:20 6:13
21:30 23:40 2:10
0:20 0:39 0:19

AVG SIGN IN TO RELEASE" 13:28

THIS AVERAGE SHOULD NOT BE 13 HOURS AND 28 MINUTES

ARGUEMENTS USED BELOW

=SUM(24-B5) +(C5) TO GET TOTAL TIME
=AVERAGE(D67:D71) TO GET AVERAGE

This is a copy spread sheet and formulas, I was given to determine how long
it takes for a Prisoner to bond out of jail.

I think the problem may be with entering 00:00 ( Midnight )to 00:59 (12:59
am) into a cell

what is wrong with this formula, I am attempting to average hours and
minutes.

GP