Hi Peter, Christopher, Dennis

Thank you all for the suggestions.

I tried formulas given by Peter and Christopher. Data and results are as
follows. 3:30 is normal SUM, modulo 24.
27.5 is some formula I tried, but it gives minutes as fraction of hour. The
Number against 'Peter' is given by Peter's formula and is exactly what I
would like. Christopher's formula gives 24.9.   Somehow I am unable to open
the file attached by Dennis. It gives some error and exits, so I am unable
to try it out.

00:30
01:30
00:55
00:50
00:45
01:10
03:50
01:10
05:30
04:25
04:00
02:55

3:30

27.5

27:30 Peter

24:9 Christopher

Once again thank you all for the suggestions. For the time being I will go
with Peter's formula, but intend to work on the formula given by Christoher
and Dennis when I can take some time out.

Vyas

From: Christopher Graham <chrisgr@SHAW.CA>


> Here's a slightly better way to do it.
>
> In the cell where you want the total enter the formula:
>
> =TEXT(24*INT(SUM(D6:D23)),"0")&":"&TEXT(MOD(SUM(D6:D23),1)*60,"0")
>
> This computes the hours and minutes parts, converts them to strings and
> concatenates them, separated by a colon.
> Replace the two D6:D23 ranges with the range containing the time values
you
> want to sum.  Format the cell as General format.  It will display the sum
in
> the format of hh:mm where the hours won't be modulo 24.
>

From: Peter (to my mail address)

>The solution to the problem is a bit more complex than just using a
>function. You have to combine them.
>
>I attached a simple example so you can see what I mean.
>
>Hopefully this solves your problem.
>

Yes it has solved my problem. Thank you.

--
http://www.piclist.com hint: PICList Posts must start with ONE topic:
[PIC]:,[SX]:,[AVR]: ->uP ONLY! [EE]:,[OT]: ->Other [BUY]:,[AD]: ->Ads