Hi
could you give an example of your data and the formula you tried?

--
Regards
Frank Kabel
Frankfurt, Germany

"llstephens" schrieb im
Newsbeitrag ...
I am given average hours per day worked and I have to give an average
hours
and minutes per week and a YTD weekly average. I can't seem to get
excel to
calculate the numbers in hours and minutes format and everytime I try
to
format the number to time, it puts an am or pm on it so it still
won't come
out with the right answer. Please Help!