View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default Need Help Please

Hi
The cell holding the cumulative time needs to be formatted as [hh]:mm
FormatCellsNumberCustom [hh]:mm

--
Regards

Roger Govier


"jlogan21" wrote
in message ...

I need some help working with times. I need to be able to add up
times
worked for 12 months of the year. For example if one workd 49 hours
and 23 minutes the month of Jan and the same for Feb, how do I do this
and keep a running sum of them? I can't see to figure out how to
format it so that it does not change to time of day since it will be
over 24 hours.
Thanks.


--
jlogan21
------------------------------------------------------------------------
jlogan21's Profile:
http://www.excelforum.com/member.php...o&userid=30111
View this thread:
http://www.excelforum.com/showthread...hreadid=506029