Last Edited By **Krjb Donovan** **Last Updated:** Mar 05, 2014 09:25 PM GMT

I am trying to find the average work time for a project. There is 3 hours, 42 minutes, and 51 seconds or 3:42:51 which I need to divide by 57 calls and add an extra 00:01:51 to each call. Can you help me figure this out?

Paula

a1: 3:42:51 a2: =(A1/57)+time(0,1,51)

so when I divide 3 hours, 42 minutes and 51 seconds by 57 I get 3 minutes and 55 seconds. When I add 1 minute and 51 seconds to that I get 5 minutes and 46 seconds is that what you want? format A2 as hh:mm:ss to see the 00:05:46

comment:
>add an extra 00:01:51 to each call
I am confused by the "to each call". I took a time and divided it by 57 resulting in an average time per call. I then added 1 minute and 51 seconds to that. If you want to then see what the total time would be for 57 calls you would so

a2: =((A1/57)+time(0,1,51))*57 and again format as hh:mm:ss

Let me know if I misunderstood what you wanted.

Advertisement

©2018 eLuminary LLC. All rights reserved.