Ecxel is not doing modulo 24 hours, but is not showing days.
Set the format for the cell that contains the total to something that
includes both date and time and you will see the days.

Furthermore there are functions that can manipulate dates.
Check out insert|function ...


Peter


On Sun, 2003-01-26 at 11:26, Vyas wrote:
> Hi,
>
> I keep number of hours worked for each project on daily basis in an Excel
> worksheet.
> At the end of the month, I would like to total number of hours worked for
> each project for the month.
>
> Now the problem is, Excel totals the time modulo 24. That is, it substracts
> 24 if hours exceed 24, while I would like it otherwise.
>
> I am unable to find anything in the help file. Any ideas? Or may be there is
> better way of keeping tab of hours worked for each project? I would like to
> avoid doing it manualy.
>
> Any help is appreciated.
>
> Vyas
>
> --
> http://www.piclist.com hint: To leave the PICList
> mailto:piclist-unsubscribe-request@mitvma.mit.edu
--
Met vriendelijke groeten,


                                                Peter O

--
http://www.piclist.com hint: To leave the PICList
mailto:piclist-unsubscribe-request@mitvma.mit.edu