adding times
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?
|