I managed the design of Excel at Microsoft for 5 years, so I hope I can
help.  I assume that what you are totalling is a bunch of numbers formatted
as hh:mm.  i.e. 2:15 for two hours and 15 minutes.

If so , the total cell, if formatted as a "general" format, would show the
duration in days, with the decimal being the fractional part of the total.
Format the total cell to general format to see this.  However, if the total
cell is formatted as hh:mm then the days are thrown away for display.   I
don't know a way to get this directly displayed in hours and not days.
However there is a way to do it.

To convert this to hours and minutes, enter a formula into another cell as
follows :

24*INT(D25)+MOD(D25,1)  .  This assumes that the cell with the total is D25.

Now format the new cell with a custom format as follows:

# ??/60    i.e. Choose custom as the format, and type this into the format
definition field in the dialog box.

This will show the total as a number of hours followed by a fraction that is
the number of minutes.   i.e. 50 13/60   if the total is 50 hours and 13
minutes.

Let me know how this works, or if you need further explanation.

- Chris Graham


----- Original Message -----
From: "Vyas" <vyas@SJVYAS.COM>
To: <PICLIST@MITVMA.MIT.EDU>
Sent: Sunday, January 26, 2003 2:26 AM
Subject: [OT]: Excel time total


> 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
>

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