I have 3000 rows of data that need to converted. I tried using a formula or reformatting the numbers but I am unable to figure it out on my own. We have a custom format of time as: [h]:mm:ss but I am unable to format without losing the data. The custom format came from the native spreadsheet, which we currently do not have access to. We only have the custom format so we cannot use the software to get a different format produced. We need someone to convert each line from the custom hour format to hours. For example if the custom hour format is: 52:15:00, we need someone to make a row that takes that number and converts it to hours in excess of 40. In other words, will produce: 12:15 (52:15 - 40). Conversely, if there is a number smaller than 40, such as 37, we need the row to read -3. Thank you.
Keyword: Data Entry
Price: $125.0
Data Entry Microsoft Excel Spreadsheet Software
I am in need of a professional data entry specialist who can help me compile text data from various online sources. The final data will need to be organized and delivered in a Google Sheets format. Ideal skills and experience for the job: - Proficient in data entry wi...
View JobI'm seeking a freelancer with experience in business administration and a strong focus on human resources. The goal is to find mid-level job opportunities that align with my skills in recruitment and staffing. Key Responsibilities: - Identify potential mid-level ...
View JobWe are looking for a reliable and organized individual to assist with the setup of a conference. This role involves working directly on-site to ensure that all elements are in place, including seating arrangements, equipment setup, and registration area organization. Th...
View Job