If Rick's formula didn't work, maybe you could share the values that are in G6
and F6.

And what you saw with Rick's formula and what you expected/wanted to see.

Damien wrote:

I tried that, but to no avail. I cant seem to figure it out. I usually just
hop on microsoft's site and look up the formula but i have exactly what they
are asking for and it still wont calculate it correctly.

"Rick Rothstein (MVP - VB)" wrote:

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?

Try putting the "h" in square-brackets...

=TEXT(G6-F6, "[h]:mm:)

Rick



--

Dave Peterson