ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Timesheet hours will not total. Help. (https://www.excelbanter.com/excel-discussion-misc-queries/1313-timesheet-hours-will-not-total-help.html)

Kelly

Timesheet hours will not total. Help.
 
I am creating a time sheet and the totals for each day are fine but when I
add all the days together they do not add properly. Excell will add two of
the days together fine but as soon as I add another day it dosn't calculate.

Frank Kabel

Hi
format your target cell with the custom format
[hh]:mm

--
Regards
Frank Kabel
Frankfurt, Germany

"Kelly" <Kelly @discussions.microsoft.com schrieb im Newsbeitrag
...
I am creating a time sheet and the totals for each day are fine but

when I
add all the days together they do not add properly. Excell will add

two of
the days together fine but as soon as I add another day it dosn't

calculate.



All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com