Listening to canaries......but got an excel formula prob...anyone able to help?...

I want to calculate a collection of times. (hours & minutes)......but obviously cannot use the normal =sum(a1:a8) example because it will not be correct time wise..help

Posted By: Steeno Steeno on August 23rd 2006 at 20:30:55

Message Thread

Listening to canaries......but got an excel formula prob...anyone able to help?... (General Chat) - Steeno Steeno, Aug 23, 20:30:55
- calculate? (General Chat) - SussexCanary, Aug 23, 20:32:30
  - cheers............I hope you can (General Chat) - Steeno Steeno, Aug 23, 20:37:00
    - try using sum but re-formatting cells as time n/m (n/m) (General Chat) - Bucks Canary, Aug 23, 20:38:20
      - yeh tried that......does not like it!....I have another 45 mins to crack it..thanks anyway (n/m) (General Chat) - Steeno Steeno, Aug 23, 20:41:48
        
        should work... (General Chat) - Bucks Canary, Aug 23, 20:45:28
        
        I'll second that (n/m) (General Chat) - Yellalee, Aug 23, 20:48:03
        
        Are the hours and min split, i.e. in two different cells? If not, (General Chat) - Yellalee, Aug 23, 20:45:07
        
        Thanks Guys!.......will give it a go...n/m (n/m) (General Chat) - Steeno Steeno, Aug 23, 20:54:18
        
        hmmm...works until you hit 24 hours!...then goes back to 0...n/m (n/m) (General Chat) - Steeno Steeno, Aug 23, 21:01:16
        
        format cells as custom [hh]:mm n/m (n/m) (General Chat) - Bucks Canary, Aug 23, 21:03:08

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.