I received an excel spreadsheet where data for time was entered in two
columns with a decimal point instead of a colon (e.g the time of twelve
thirty four was entered as 12.34 instead of 12:34). Is there any way I can
insert a formula to convert the data to the correct format so that I can
calculate the time elapsed correctly? Thanks