Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
For my job i have to track my own hours. I am trying to make a sheet that
will add up my own hours for me. I have four columns that I type in my hours and then I total it for the day using "=TEXT(G6-F6, "H:MM")". But then when I try to total it for the week it comes up with a screwy number once I go over a 24 hour period. I tried typing "=SUM(I6:I12)*24" but it still doesnt add up correctly. What am i doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help Please on adding times | Excel Discussion (Misc queries) | |||
Adding times | Excel Worksheet Functions | |||
Adding times | New Users to Excel | |||
Adding times | Excel Worksheet Functions | |||
Adding times together | Excel Worksheet Functions |