Have you actually tried it?
--
HTH
Bob Phillips
"Coco" wrote in message
...
It does not work because I have the cells that's being calculated in time
formate so I had to formate the cell using the Text function in order for
it
to calculate the diffence between the times.
"Bob Phillips" wrote:
Why not just use
=D12-C12
and format as "hh:mm"
in the total box, format as [hh]:mm
--
HTH
Bob Phillips
"Coco" wrote in message
...
I am using =TEXT(D12-C12,"h:mm") to add the time between to times but
I
can't
total the hours for the week. I use the function SUM(E10:E31) but it
does
not work. I think it is because of the text format of the function
that I
used above.
I appreciate anyone's help.
Thanks.
|