Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
formula for adding up total hours in a time sheet
2 views
Skip to first unread message
Louis
Nov 22, 2003, 3:47:53 PM11/22/03
to
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?
=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
Jason Morin
Nov 22, 2003, 3:57:02 PM11/22/03
to
Custom format your formula cell as [h]:mm
HTH
Jason
Atlanta, GA
>.
>
Louis
Nov 22, 2003, 4:14:52 PM11/22/03
to
>.
>The cell is formated to h:mm
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
anon...@discussions.microsoft.com
Nov 22, 2003, 4:28:04 PM11/22/03
to
>>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
underneath "Type".
Jason
Peo Sjoblom
Nov 22, 2003, 4:29:02 PM11/22/03
to
Did you what Jason said? Change the format to custom [h]:mm
--
Regards,
Peo Sjoblom
"Louis" <Lou...@comcast.net> wrote in message
news:015101c3b13d$abb122e0$a401...@phx.gbl...
anon...@discussions.microsoft.com
Nov 23, 2003, 6:13:19 AM11/23/03
to
formats in the cell then reformat the cell with the
proper time function good luck.
0 new messages