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
Looking to employ a remote assistant that is punctual, takes tasks seriously until completed, time conscious, multitask when needed, good communication and written skill. You'll performing basic day to day administrative duties. Pretty flexible hours (15-18 hours needed...
View JobI am in need a bookkeeper for 10-20 hours a week. We purchase, rehab, and rent single family homes. I need someone who is very familiar with how to properly apply properties to the balance sheet, cap ex, run desired reports. So please let me know what experience you hav...
View JobWe need help migrating content for a website we are building. The old site is an Umbraco 8 site and the new site is an Umbraco 13 site using uSkinned. We are looking for someone with Umbraco experience and we will also provide some training and general guidance. We are ...
View Job