If you are working on a spreadsheet that has numbers in the spreadsheet labeled as labels, there is a way to convert the labels to numbers. Changing them to numbers helps in calculating those numbers in Excel.
Insert a column next to the column you would like to convert. As in the spreadsheet below, where it reads 2:00, click on the column next to that, type in =Value(name of cell; b3, etc)*24 and hit “Enter.” You will then be able to click on the bottom right corner of the cell and drag it down to where you want the labels to be numbers in the spreadsheet.
Tags: Microsoft Office, software