Prev: Selecting specific cells in a column using countif
Next: Ignore Blanks
From: da on 27 Apr 2010 14:19
Hello
I am not getting total sum when trying to add following times. I have used
H;mm format. I get total of 9:20, which is wrong. How can I get accurate
total?
Thanks
1:50
0:45
0:40
2:40
1:40
0:20
0:30
0:00
1:30
0:25
2:40
2:30
2:30
2:40
0:50
1:05
2:15
4:00
1:20
2:40
0:50
0:25
1:10
2:00
0:50
2:25
2:15
1:50
0:50
1:40
2:50
2:45
2:30
2:30
2:35
2:10
4:30
0:55
2:30
2:40
2:45
2:30

From: FSt1 on 27 Apr 2010 14:31
hi
try format [hh]:mm:ss

Regards
FSt1

"da" wrote:

> Hello
> I am not getting total sum when trying to add following times. I have used
> H;mm format. I get total of 9:20, which is wrong. How can I get accurate
> total?
> Thanks
> 1:50
> 0:45
> 0:40
> 2:40
> 1:40
> 0:20
> 0:30
> 0:00
> 1:30
> 0:25
> 2:40
> 2:30
> 2:30
> 2:40
> 0:50
> 1:05
> 2:15
> 4:00
> 1:20
> 2:40
> 0:50
> 0:25
> 1:10
> 2:00
> 0:50
> 2:25
> 2:15
> 1:50
> 0:50
> 1:40
> 2:50
> 2:45
> 2:30
> 2:30
> 2:35
> 2:10
> 4:30
> 0:55
> 2:30
> 2:40
> 2:45
> 2:30
>
From: da on 27 Apr 2010 14:36
Thanks
I changed the format as suggested. But, I still get total 9 hours and 20
minutes, which is worng.

"FSt1" wrote:

> hi
> try format [hh]:mm:ss
>
> Regards
> FSt1
>
> "da" wrote:
>
> > Hello
> > I am not getting total sum when trying to add following times. I have used
> > H;mm format. I get total of 9:20, which is wrong. How can I get accurate
> > total?
> > Thanks
> > 1:50
> > 0:45
> > 0:40
> > 2:40
> > 1:40
> > 0:20
> > 0:30
> > 0:00
> > 1:30
> > 0:25
> > 2:40
> > 2:30
> > 2:30
> > 2:40
> > 0:50
> > 1:05
> > 2:15
> > 4:00
> > 1:20
> > 2:40
> > 0:50
> > 0:25
> > 1:10
> > 2:00
> > 0:50
> > 2:25
> > 2:15
> > 1:50
> > 0:50
> > 1:40
> > 2:50
> > 2:45
> > 2:30
> > 2:30
> > 2:35
> > 2:10
> > 4:30
> > 0:55
> > 2:30
> > 2:40
> > 2:45
> > 2:30
> >
From: Bob I on 27 Apr 2010 14:52
Use HH:mm

da wrote:

> Hello
> I am not getting total sum when trying to add following times. I have used
> H;mm format. I get total of 9:20, which is wrong. How can I get accurate
> total?
> Thanks
> 1:50
> 0:45
> 0:40
> 2:40
> 1:40
> 0:20
> 0:30
> 0:00
> 1:30
> 0:25
> 2:40
> 2:30
> 2:30
> 2:40
> 0:50
> 1:05
> 2:15
> 4:00
> 1:20
> 2:40
> 0:50
> 0:25
> 1:10
> 2:00
> 0:50
> 2:25
> 2:15
> 1:50
> 0:50
> 1:40
> 2:50
> 2:45
> 2:30
> 2:30
> 2:35
> 2:10
> 4:30
> 0:55
> 2:30
> 2:40
> 2:45
> 2:30
>

From: Luke M on 27 Apr 2010 14:55
With a format of:
[h]:mm
I get an answer of 78:15

Also, even with a regular format of:
h:mm
I get an answer of 6:15

--
Best Regards,

Luke M
"da" <da(a)discussions.microsoft.com> wrote in message
news:82278F41-B973-417B-944F-AD2824470704(a)microsoft.com...
> Thanks
> I changed the format as suggested. But, I still get total 9 hours and 20
> minutes, which is worng.
>
> "FSt1" wrote:
>
>> hi
>> try format [hh]:mm:ss
>>
>> Regards
>> FSt1
>>
>> "da" wrote:
>>
>> > Hello
>> > I am not getting total sum when trying to add following times. I have
>> > used
>> > H;mm format. I get total of 9:20, which is wrong. How can I get
>> > accurate
>> > total?
>> > Thanks
>> > 1:50
>> > 0:45
>> > 0:40
>> > 2:40
>> > 1:40
>> > 0:20
>> > 0:30
>> > 0:00
>> > 1:30
>> > 0:25
>> > 2:40
>> > 2:30
>> > 2:30
>> > 2:40
>> > 0:50
>> > 1:05
>> > 2:15
>> > 4:00
>> > 1:20
>> > 2:40
>> > 0:50
>> > 0:25
>> > 1:10
>> > 2:00
>> > 0:50
>> > 2:25
>> > 2:15
>> > 1:50
>> > 0:50
>> > 1:40
>> > 2:50
>> > 2:45
>> > 2:30
>> > 2:30
>> > 2:35
>> > 2:10
>> > 4:30
>> > 0:55
>> > 2:30
>> > 2:40
>> > 2:45
>> > 2:30
>> >


 |  Next  |  Last
Pages: 1 2
Prev: Selecting specific cells in a column using countif
Next: Ignore Blanks