Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
When I add time - Example 10 days of 8 hours each I receive 81.46
I have caluclated a time sheet and everything look fine until i add the total
hours. -- Kathy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
When I add time - Example 10 days of 8 hours each I receive 81.46
Are you sure you don't have some stray seconds being accumulated. Change the
formats to hh:mm:ss and see. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kathy" wrote in message ... I have caluclated a time sheet and everything look fine until i add the total hours. -- Kathy |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
When I add time - Example 10 days of 8 hours each I receive 81.46
Hi Kathy,
Unless you post the question within the body of the question, it will most likely not be seen by most people, and will confuse. Your question is in the subject. Most likely you have tried to simply what you think is the case and you don't really see what you say you see, Unless your figures show as a single digit until your total. Your numbers are calculated and are not really 8. Display the figures to 3 decimal places would probably show the problem but of course not be what you want. You may want to ROUND the figures that you are using depending on how the time sheets are actually calculated. Rounding Errors and Precision http://www.cpearson.com/excel/rounding.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kathy" wrote in message ... I have caluclated a time sheet and everything look fine until i add the total hours. -- Kathy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
Calculate difference in time spanning a day, during office hours o | Excel Discussion (Misc queries) | |||
comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
Elapsed time Calc...over 30 days long... | Excel Discussion (Misc queries) | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |