Thank you. This worked out well.
"Bernard Liengme" wrote:
Replace the formula by =A2-A1 and format [h]:mm (the [] stops 25 becoming 1)
using Format|Cells-custom
Now you can add the data in two or more cells.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Jaclyn" wrote in message
...
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!