View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oldchippy oldchippy is offline
external usenet poster
 
Posts: 1
Default When I add time - Example 10 days of 8 hours each I receive 81.46


Kathy Wrote:
I have caluclated a time sheet and everything look fine until i add the
total
hours.
--
Kathy

Hi Kathy,

Format time to add up with [hh]:mm, take a look at this link as well

http://www.ozgrid.com/Excel/times-past-24.htm

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=571051