add and subtract values in xml string
Posted on 2015-02-09
A little programming question. I have a fingerprint time clock that outputs to a xml file that is formatted for spreadsheets. Problem is this. If a person clocks in first thing in the morning and clocks out for lunch and then back in and back out at the end of the day, the Time clock puts all the time values inside one cell, or string (if you open it with Notepad). Is there a way to take this data and calculate a total time at work for that one day? Or am I stuck with manually calculating it up.