You are reading a single comment by @Mr_Sworld and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Mr_Sworld
Can you make an intermediary sheet - i.e. one that takes your time recording output, and reformats it into the columns needed in the right order for the work spreadsheet. then you can just do a copy paste.
For example, if Time Recoder outputs:
Col A | Col B | Col C | Col D
Date | Time start | Time End | Client
and the work spreadsheet needs:
Client | Date | Total hourse
Then you can write a sheet that formulas off the time recoder sheet thus:
Client | Date | Total hours
= ColD | =ColA | =ColC - ColB
Any use?