formula for adding up total hours in a time sheet

  • Thread starter Thread starter Louis
  • Start date Start date
L

Louis

I have this formula:
=sum(G25:G29) for adding up the 8:00 hours per day and
instead of adding up to 40, it adds up to 16:00. What am
I doing wrong?

Louis
 
-----Original Message-----
Custom format your formula cell as [h]:mm

HTH
Jason
Atlanta, GA
-----Original Message-----
I have this formula:
=sum(G25:G29) for adding up the 8:00 hours per day and
instead of adding up to 40, it adds up to 16:00. What am
I doing wrong?

Louis

.
Click to expand...
.
The cell is formated to h:mm
Click to expand...
When I do a control and click on the both of the weekly
totals, it shows 80 hours (for 2 weeks) on the status bar
below but on the in the cell on the spreadsheet it still
shows 16:00

Louis
 
The cell is formated to h:mm

You must custom format the cell as [h]:mm. The [] tells
Excel to roll over the hours (past 24:00). Format > Cells
Number tab, click Custom, and insert [h]:mm on the right
Click to expand...
underneath "Type".

Jason
 
Did you what Jason said? Change the format to custom [h]:mm

--

Regards,

Peo Sjoblom

Louis said:
-----Original Message-----
Custom format your formula cell as [h]:mm

HTH
Jason
Atlanta, GA
-----Original Message-----
I have this formula:
=sum(G25:G29) for adding up the 8:00 hours per day and
instead of adding up to 40, it adds up to 16:00. What am
I doing wrong?

Louis

.
Click to expand...
.
The cell is formated to h:mm
Click to expand...
When I do a control and click on the both of the weekly
totals, it shows 80 hours (for 2 weeks) on the status bar
below but on the in the cell on the spreadsheet it still
shows 16:00

Louis
Click to expand...
 
-----Original Message-----
I have this formula:
=sum(G25:G29) for adding up the 8:00 hours per day and
instead of adding up to 40, it adds up to 16:00. What am
I doing wrong?

Louis

All the cells must be formated the same Clear all
Click to expand...
formats in the cell then reformat the cell with the
proper time function good luck.
 
Back
Top