Hello,
I'm using Office 2010 and I want to calculate the average of hours worked for about 40 employees on a monthly basis. The employees all work from about 160 to about 200 hours. My fields are formatted as time but when I use average I always get a #Div/0 error. How do I correct this?
Examples
Agent name Total shift time
(hh:mm:ss)
Jacqueline 140:17:26
Julio 202:41:34
Wendy 178:56:11
Rosa 194:49:04
Cesar 206:09:47
Stephanie 152:05:47
Cecilia 158:06:00
Victoria 155:56:51
When I use average I get Div/) error or an average like 21 hours which looks like it cuts off the first digit of the hours (150 hours becomes 50 hours?)
Please help
Bookmarks