I have a dataset exported from a Time & attendance system. The dataset format is in hh:mm, e.g., 24:45 equals 24.75 hours.
The dataset contains total hours distributed by employee (row) and pay code (column). Some pay code totals are negative, so when I export to Excel 2010 some fields will contain values that look like this: -56:00.
When I use /24 to reformat the cells to decimal values, the cells with negative values do not calculate correctly, obviously because the first character is a minus sign.
How do I convert the negative time value, e.g.: "-56:00" -- to a negative decimal value: "(56.00)"?
The dataset contains total hours distributed by employee (row) and pay code (column). Some pay code totals are negative, so when I export to Excel 2010 some fields will contain values that look like this: -56:00.
When I use /24 to reformat the cells to decimal values, the cells with negative values do not calculate correctly, obviously because the first character is a minus sign.
How do I convert the negative time value, e.g.: "-56:00" -- to a negative decimal value: "(56.00)"?
