You could convert that back to a usable time with =time(a3) (if the formula
you have is in A3); format the result as a time. But even easier, skip the
conversion to text and back. Instead of =text(...), just use =a2-a1,
formatted as a time. This is readable, and still usable in further
calculations.
--Bruce

"Jaclyn" wrote:

I am trying to create a timecard which allows work shifts that span days. I
enter "time in" and "time out" for each shift in the format "mm/dd/yyyy
hh:mm:ss". To find the total time at the end of a shift I used
"=TEXT(A2-A1,"h:mm")" to subtract the time in from the time out, which gives
me the total hours and minutes worked each shift. Now I can't seem to find a
way to add all of the resulting shift times together to get a weekly total.

All suggections welcome. Thank you!