How do I add times calculated using =TEXT(D40-C40+(F40-E40),"h:mm"

[Marcus B]

I am not able to add times together that have been calculated using this
formula =TEXT(D40-C40+(F40-E40),"h:mm"). I have created a time sheet that
calculates the time worked each day, but I'm not able to sum the total time
for each day of the week. Please help.

 

[Pete_UK]

See if this array* formula works for you:

=SUM(VALUE(G2:G40))

assuming you want to add values in the range G2 to G40 - adjust to suit
your data and format the cell as [h]:mm.

* As this is an array formula, then once you have typed it in (or
subsequently edit it) you must use CTRL-SHIFT-ENTER rather than just
ENTER. If you do this correctly then Excel will add curly braces { }
around the formula - you must not type these yourself.

Hope this helps.

Pete