MS Excel 2003
I am creating a timesheet that is based on 8-hour days. The first column is labeled "Total Hours" which represents the total hours someone works. My spreadsheet has VBA code that convert numbers to time notation.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
I also have a formula in each row (=IF(L8=0,SUM(C8:D8),(IF(L8=0,0,IF(SUM(C8:J8,M8)=0,8,L8+C8+D8-SUM(E8:J8)+M8))))).
<o></o>
If there are no entries in range C8:J8,M8, the result should be 8:00 vs. 192:00. If I divide the aforementioned formula by 24, the result is a blank cell vs. 8:00. However, an entry of: 30 in cell F8, for example, displays the proper result (7:30 total hours).
<o></o>
What do I need to do so that the total hours for the day show 8:00? The format is [h]: mm.
I am creating a timesheet that is based on 8-hour days. The first column is labeled "Total Hours" which represents the total hours someone works. My spreadsheet has VBA code that convert numbers to time notation.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>I also have a formula in each row (=IF(L8=0,SUM(C8:D8),(IF(L8=0,0,IF(SUM(C8:J8,M8)=0,8,L8+C8+D8-SUM(E8:J8)+M8))))).
<o
></o>If there are no entries in range C8:J8,M8, the result should be 8:00 vs. 192:00. If I divide the aforementioned formula by 24, the result is a blank cell vs. 8:00. However, an entry of: 30 in cell F8, for example, displays the proper result (7:30 total hours).
<o
></o>What do I need to do so that the total hours for the day show 8:00? The format is [h]: mm.
Last edited:
